Forum Discussion
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 it will flow through to the Regional Manager slicer and that my visual would then immediately filter to that Regional Manager level. Which is what I wanted
However, it seems as though the Regional Manager slicer stays showing "All" and unless I go into the slicer and select the single option Regional from the slicer Dropdown menu my visual will not change. It wont even change if I choose the "Select All" option at the top.
Is there something I'm missing? The slicer fields are from the same table so it isn't a filter direction issue. Any help is appreciated.
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.
4 Replies
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
Thanks for your reply. This is essentially the issue. The visual is set to ignore the Manager slicer, but not the Regional Manager Slicer. I would hope that selecting a Manager would result in the Regional Manager slicer getting updated (in this case John Smith) but the visual doesn't only show John Smith. It still shows them all. Is there any way to allow the visual's Regional Manager to be filter by selecting a Manager ? Is there not a way to preselect all values in the Regional Manager slicer instead of still being required to click that slicer also?
There is no way to preselect values in your slicer unfortunately, Have you thought about adding the regional manager column into the same slicer as your manager column to create a hierarchy? This does not resolve your issue but it will be more user friendly...
- Charles Park
- Christina Kay
- Darren Hardin
- Karen Gibson
> John Smith
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.
