The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
86 | |
84 | |
36 | |
34 | |
34 |
User | Count |
---|---|
94 | |
79 | |
65 | |
55 | |
52 |