Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
yvonniecm08
Regular Visitor

Implementing Predefined Measure Groups in Matrix Table via Parameter Filtering

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, w
hen 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!
1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_1-1744081471245.png

 

 

Jihwan_Kim_0-1744081441442.png

 

 

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)
}

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

4 REPLIES 4
v-bmanikante
Community Support
Community Support

Hi @yvonniecm08 ,

 

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
Community Support
Community Support

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
Community Support
Community Support

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

Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_1-1744081471245.png

 

 

Jihwan_Kim_0-1744081441442.png

 

 

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)
}

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.