Implementing Predefined Measure Groups in Matrix Table via Parameter Filtering

[Anonymous]

Hi everyone,

I’m currently working on a matrix table in Power BI (Fabric) where I’m using a dynamic column filter based on a parameter. The goal is to allow users to choose which column to display in the matrix, and I followed this tutorial to set it up: 

This setup works, but the matrix only shows one column at a time because all the possible values (like Value, MoM Change, MoM %, YoY Change, etc.) are bundled into one parameter field.

Here’s what I want to achieve now: I want to create predefined filters (like buttons or slicers) where, for example, clicking "MoM" would display both "MoM Change" and "MoM %" at the same time in the matrix. Similarly, clicking "YoY" would show "YoY Change" and "YoY %", and so on. Basically, a way to group related measures and show them together with a single click.

I’m wondering how to implement this kind of grouped column filtering in the matrix visual. Has anyone done something similar or has suggestions?

Example of what I want to happen visually:

When selecting "MoM" group filter:

Category MoM Change MoM %

Product A	+50	+5%
Product B	-20	-2%

Then, when selecting "YoY" group filter:

Category YoY Change YoY %

Product A	+100	+10%
Product B	-30	-3%

What I'm trying to achieve is that when I click on a predefined filter (like “MoM” or “YoY”), the matrix table automatically updates to show only the related columns. So if I click “MoM”, it shows MoM Change and MoM %; if I click “YoY”, it shows YoY Change and YoY %, and so on.

This would allow users to quickly switch views between grouped calculations, instead of selecting one column at a time.

Thank you in advance to anyone who can help or guide me on how to approach this!

[v-bmanikante]

Hi @Anonymous ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @yvonniecm08 ,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Anonymous ,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

B Manikanteswara Reddy

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure about how your semantic model looks like, but I tried to create a sample pbix file like below.

One of ways is to create a parameter and add more columns (for grouping purpose) by fixing the parameter formula like below.
Please check the below picture and the attached pbix file.

Parameter_Measures = {
    ("YoY", NAMEOF('sales'[YoY]), 0, "YoY", 1),
    ("YoY %", NAMEOF('sales'[YoY %]), 1, "YoY", 1),
    ("MoM", NAMEOF('sales'[MoM]), 2, "MoM", 2),
    ("MoM %", NAMEOF('sales'[MoM %]), 3, "MoM", 2)
}