topic Re: Syncronized matrix headers in Custom Visuals Development Discussion

Syncronized matrix headers

dk_patriot — Thu, 19 Dec 2024 13:02:36 GMT

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

Re: Syncronized matrix headers

lbendlin — Thu, 19 Dec 2024 20:47:58 GMT

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.

Re: Syncronized matrix headers

dk_patriot — Fri, 20 Dec 2024 07:40:31 GMT

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.

Re: Syncronized matrix headers

lbendlin — Fri, 20 Dec 2024 13:47:11 GMT

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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523