Martix columns based on User selections

[Snagalapur]

Hi All,

Please suggest calculation to build toggle/option (using parameters) where i can control matrix columns display based on selection

EX: below matrix table having different measures, when we click on Values it should display Actual,Budge and Forecast columns only.

[MFelix]

Hi @Snagalapur ,

For this you should use Field Parameters that allows you to control the measures to be presented on the selection.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

You can add a column to the table that is created to make a slicer with Values / Quantity so you can have it controlled over the measures you need.

[Snagalapur]

could you please suggest how to group these columns into value and Quantity . thank you

[MFelix · Accepted solution]

Hi @Snagalapur ,

In the field parameter table you just need to add an additional column with the classification of each one:

Fied Parameter = {
    ("Measure 1", NAMEOF('Table'[Measure 1]), 0, "Values"),
    ("Measure 2", NAMEOF('Table'[Measure 2]), 0, "Values"),
    ("Measure 3", NAMEOF('Table'[Measure 3]), 0, "Values"),
    ("Measure 4", NAMEOF('Table'[Measure 4]), 0, "Quantity"),
    ("Measure 5", NAMEOF('Table'[Measure 5]), 0, "Quantity"),
    ("Measure 6", NAMEOF('Table'[Measure 6]), 0, "Quantity")
}

This will create a new column called Value4 but you can rename it just double clicking the name, then you can use it on a slicer to make the filtering of each of the measure presented.