Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've tried to search for this, but can't find anything as the wording is difficult to make unique, so apologies. This will have been asked before, I just can't find it.
If I have a simple table like this:
Building Name | Department |
Building 1 | IT |
Building 1 | HR |
Building 1 | Finance |
Building 2 | Transport |
Building 2 | Admin |
Building 2 | Security |
I set up 2 slicers, the first is based on Building Name, the second on Department. The department slicer will dynamically change based on which building I choose from the Building slicer.
However, if I choose a department, then change Buildings, the incorrect department option will continue to be selected until I select something else. I.e. If I choose Building 1, choose Finance from the Department slicer, then choose Building 2 from the Building slicer, Finance will remain selected on the Department slicer until I choose another department.
It isn't report breaking, but it looks really unprofessional when all the visuals are either blank or are freaking out because they can't parse the data they've been given.
Is there any way to force the Department slicer to select a default option when the Building slicer changes?
Solved! Go to Solution.
I'm afraid that's the nature of the beast. You can add a button to clear slicers (using a bookmark) and/or a text box instructing users to clear slicers when needed.
Proud to be a Super User!
Paul on Linkedin.
I'm afraid that's the nature of the beast. You can add a button to clear slicers (using a bookmark) and/or a text box instructing users to clear slicers when needed.
Proud to be a Super User!
Paul on Linkedin.
Thanks dude. I more or less assumed that would be the case, I just thought I'd ask the question on the off chance I was missing something.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |