Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Anonymous
Not applicable

Filtering problem

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  

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Just figured out this doesn't work with bullet charts but will work with bar charts. 

View solution in original post

3 REPLIES 3
PaulDBrown
Community Champion
Community Champion

Hi, 

 

You can use slicers or the filter pane to achive what you are looking for. 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

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.

 

 

 

Anonymous
Not applicable

Just figured out this doesn't work with bullet charts but will work with bar charts. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.