Forum Discussion
undefined
Show and hide measures dynamically in a visual based on users solution Table : product table Column name : amount ,sales,units sold. Slicer : amount ,sales , units sold .If I click particular c...
Hi, Karthikgayathri
You can use a combination of slicers and the SILECTEDVALUE function. for example.
Firstly, you need to create a table with the names of the measures you want to show and hide. This can be done in the Modeling tab, under "New Table". The DAX formula might look something like this:
MeasureTable = DATATABLE ( "Measure", STRING, { {"Amount"}, {"Sales"}, {"Units Sold"} } )
Then, create a slicer using this table. This will allow your users to select which measure they want to see.
Next, create a new measure which uses the selected value from the slicer to decide which measure to show. This might look something like:
Selected Measure = SWITCH ( SELECTEDVALUE ( MeasureTable[Measure] ), "Amount", SUM ( productTable[amount] ), "Sales", SUM ( productTable[sales] ), "Units Sold", SUM ( productTable[unitsSold] ) )
Now, if you create a visual using this new measure, it will show the value of the measure selected in the slicer, and hide the other measures.