Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
79 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |