Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
Solved! Go to Solution.
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
55 | |
38 | |
31 |
User | Count |
---|---|
78 | |
64 | |
64 | |
49 | |
45 |