Forum Discussion
Slicer Interactions Not Adjusting Visual Properly
- Anonymous2 years ago
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.