Forum Discussion
Anonymous
1 year agoNot applicable
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 i...
- 1 year ago
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) }
Anonymous
1 year agoNot applicable
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