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

Help with visual level filters

Hi,

 

We have a problem which cannot solve. I've added a simple table with 3 charts, we use this case often, same charts with same visual level filters but on different dimension. The problem we have is when you filter on any bar chart all other filter to zero, since that dimension is excluded in visual level filter on other charts.

 

Is there a way to override this, with some IF ISFILTERED or something like that. The case for us would be to filter on month when you click on bar chart, but on other graphs to also only filter on month, disregard the dimension and keep it as is in visual level filter on that specific chart

 

Hope I explained correct. I've also added a phote to see the problem we haveCapture.JPG

 

Thanks, 

Dragan

 

https://www.dropbox.com/s/2a6hxwsa5pmnaf8/Test%20Report.pbix?dl=0

3 REPLIES 3
iamprajot
Responsive Resident
Responsive Resident

Select Charts > Go to Format > Click Edit Interactions > select the no impact icon - repeat this step for other charts too.
Or for better understanding read the below
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

 

Hope it helps.

Mark it as Solution to help others looking for answers.

Anonymous
Not applicable

This is not a solution since when we filter on previous months we would like to see that specific month filtered,

 

Aslo we are using KPI tile on top of that and we would also like it to revert to specific month when filtered on that month.

 

So it would definettly need to be some change in measure to disregard this visual level filter

 

Thanks

Anonymous
Not applicable

Capture.JPG

 

for instance one case is like this, thats why we would like to fix this with DAX if possible

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.