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.
Hi guys,
I have 4 visuals in my report.
- managers (bar chart) - showing YTD actuals vs YTD budget
- products (bullet chart) - showing YTD actuals vs YTD budget
- branch (bullet chart) -showing YTD actuals vs YTD budget
- region (bullet chart) -showing YTD actuals vs YTD budget
the interactions work perfectly but the problem i need to fix is that when i click on a manager in the bar chart and then i click on a product in the bullet chart in removes the filter from the manager visuals and shows all managers.
How do i set the visuals so that when i click on a manager and then click on another visual it wont remove my filter in the manager visual.
Thanks
Solved! Go to Solution.
Just figured out this doesn't work with bullet charts but will work with bar charts.
Hi,
You can use slicers or the filter pane to achive what you are looking for.
Proud to be a Super User!
Paul on Linkedin.
Hi there,
I do have a slicer pane. But i need to figure out a way to lock the visual from filtering when i click on another.
for example.
I filter on Visual A by clicking on a bar and then Visual B and C changes accordingly but while Visual A is filtered i want to select a bar from visual B and it must not remove the filter on visual A but it must beable to filter visual C. Keep in mind that i am using bar graphs in these visuals.
Just figured out this doesn't work with bullet charts but will work with bar charts.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |