Syncronized matrix headers

[dk_patriot]

I have two matrix visuals. Right one is filtered according to individual farm (crops grown over a period of time) and the left one is filtered so that it shows the average of all farms but only the most recent year for the individual farm and the crops grown on the individual farm. This is achieved by using a TOPN visual filter.

I would like to have the to row headers (list of crops(afgrøde)) in sync. As shown in the manipulated image on the bottom (forced visiual filter). 

I want to filter the matrix on the right so that it has all the crops that has been grown in period (2015-2023) of the individual farm showing averages for all other farms. However still maintaining the filter to the most recent year and the cross filtering capabilities when clicking on previous years on the matrix on the right. 

Matrix row headers not in sync

Matrix row headers (manipulated) in sync

[lbendlin]

read about how to "sort a column by another column".  Create a reference table with the desired sort order. Use that table for the row field.

[dk_patriot]

Thanks for reply. The sorting isn't quite the problem. The problem is that some rows headers are not present because there are no values in the selected year for the individual farm. I need to have a dedicated table that filters according to which farm I'm looking at. That table needs to contain a list of crops that has been grown by the individual farm over the entire period. 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...