Forum Discussion

Karthikgayathri's avatar
Karthikgayathri
Helper I
3 years ago

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 column name in slicer ,only filter particular column other column need not be visible 

 

 

 

 

 

 

Need Help
Tips and Tricks

1 Reply

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    3 years ago

    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.