Forum Discussion
Helper IVMartix columns based on User selections
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.
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.
3 Replies
- MFelix
Super User
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.
Snagalapurcould you please suggest how to group these columns into value and Quantity . thank you
- MFelix
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.