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

Hi danextian, we implemented it in our file and it is working, however there is some change in requirement we need to make Sub brand slicer as single select with All as a selection which we have implemented. We implemented this by making Sub brand all column and appending existing values once again and input "All" in table front of it, now we want to implement it for this use case. Can you suggest any solution for this? Let me know if any clarification is required.