Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Disable particular slicer value based on another slicer selection

I have 2 slicers. 1 Represents MTD/QTD/YTD/Custom and another is comparison slicer PM/PQ/PY.

I wanted to write a measure such that if MTD is selected, comparison slicer will show PM and PY, in case of QTD, only PQ and PY and for YTD and custom, Just PY.
Can it be done on visual filter level? 

Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Anonymous , Create a measure on the table of the second slicer and then use that in visual level filter

     

    Switch(True(),
    max(S2[Col]) in {"PM", "PY"} && selectedvalue(S1[col]) = "MTD", 1,

    max(S2[Col]) in {"PQ", "PY"} && selectedvalue(S1[col]) = "QTD", 1,

    max(S2[Col]) in {"PY"} && selectedvalue(S1[col]) = "YTD", 1,

    0)

     

    Choose value =1 for this measure in the visual level filter of slicer

    Refer

    How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    Anonymous , Create a measure on the table of the second slicer and then use that in visual level filter

     

    Switch(True(),
    max(S2[Col]) in {"PM", "PY"} && selectedvalue(S1[col]) = "MTD", 1,

    max(S2[Col]) in {"PQ", "PY"} && selectedvalue(S1[col]) = "QTD", 1,

    max(S2[Col]) in {"PY"} && selectedvalue(S1[col]) = "YTD", 1,

    0)

     

    Choose value =1 for this measure in the visual level filter of slicer

    Refer

    How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8