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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
AndrewPF
Helper V
Helper V

ISFILTERED using charts instead of filters

I have a chart which I want to be populated only when a particular variable is selected. 

I therefore have a slicer with that variable, the chart is filtered by a measure which uses the ISFILTERED function, and it all works fine. 

However, I don't want the slicer there.  I want the chart to be populated only when I select this variable from a different chart. 

But I can't get it to work properly. 

Is it possible?  Does the ISFILTERED function only work for slicers?  

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

Are you using the same column in your slicer as you are using in the chart, or is maybe one coming from a dimension table and one from a fact table ?

The easiest way to see exactly which filters are being applied is to use Performance Analyzer to get a copy of the query generated for the chart you want to be filtered, making sure that you have selected the variable in another chart. Examine the query in DAX Studio and it will show you which tables and columns are being filtered.

It may be that you need to use ISCROSSFILTERED instead of ISFILTERED. 

If you only want to make sure that the variable has a single value then you could use HASONEVALUE.

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

Are you using the same column in your slicer as you are using in the chart, or is maybe one coming from a dimension table and one from a fact table ?

The easiest way to see exactly which filters are being applied is to use Performance Analyzer to get a copy of the query generated for the chart you want to be filtered, making sure that you have selected the variable in another chart. Examine the query in DAX Studio and it will show you which tables and columns are being filtered.

It may be that you need to use ISCROSSFILTERED instead of ISFILTERED. 

If you only want to make sure that the variable has a single value then you could use HASONEVALUE.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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