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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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