Forum Discussion

IM_TRYING_HERE's avatar
IM_TRYING_HERE
Frequent Visitor
2 years ago
Solved

Slicer Interactions Not Adjusting Visual Properly

I have a visual that I only want to be "sliced" at the Regional Manager level, so I set it up to ignore the "Property Manager" slicer. I assumed that if someone did use the Property Manager slicer...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi IM_TRYING_HERE 

     

    Thanks for the reply from Ritaf1983 and IM_TRYING_HERE .

     

    IM_TRYING_HERE , if you can accept the two slicer fields as a separate table, please refer to the following test:

     

    My sample:

     

    1. create a calculated table as follows

    Slicer = SELECTCOLUMNS('Table', [Manager], [Regional Manager])

     

    no relationship between two tables

     

    2. Create a measure as follows

    Measure = 
    VAR _RM = MAX('Slicer'[Table_Regional Manager])
    RETURN
    IF(SELECTEDVALUE('Table'[Regional Manager]) = _RM, 1, 0)

     

    3. Put the measure into the visual-level filters, set up show items when the value is 1.

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.