Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
  • Jihwan_Kim's avatar
    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)
    }