Power BI — show and hide measures on slicer
In some cases you want to see all measures on your visualizations. In some instances you want to manipulate a visibility of your calculations. Today I tell you how you can show or hide measures depending on your needs.
The first step is to create standard measures:
The next step, we need to create a table containing names of the measures. This table (column) is used to integrate values into a slicer. And to establish a column values on visualizations.
Moving forward we have to create the measure, which is responsible for showing or hiding selected measures.
Once we have everything ready. We can create visualizations: a matrix and a line chart.
Put a chosen category label into the rows (matrix) and axis (line chart) section.
Locate a [Measure name] column from the previously created the [Sales select measure] table, place into the columns (matrix) and columns (line chart) section.
Insert the [Select measure] measure into the values field (in both cases).
A matrix setup:
A line chart settings:
And here is a demo.