Forum Discussion

sagittarius_111's avatar
sagittarius_111
Frequent Visitor
1 year ago
Solved

Slicer

We have two slicers, one of which is field parameter containing values like age, race, gender, brand, sub brand. Second slicer is Sub Brand slicer having values for different sub brands. The ask is li...
  • danextian's avatar
    danextian
    1 year ago

    Hi sagittarius_111 

     

    Create a measure that check whether Sub Brand isfiltered and if the Parameter Order is equal to that of Sub Brand in the parameters table.

    Hide Product =
IF (
    ISFILTERED ( financials[Product] )
        && SELECTEDVALUE ( Parameter[Parameter Order] ) = 3,
    0,
    1
)

    Use this measure as a visual filter.

     

     

     

sagittarius_111's avatar
sagittarius_111
Frequent Visitor
1 year ago

Thanks for helping out, I will try your approach