Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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:
Product A | +50 | +5% |
Product B | -20 | -2% |
Then, when selecting "YoY" group filter:
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.
Solved! Go to 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)
}
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
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
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
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)
}
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |