Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
We have a problem which cannot solve. I've added a simple table with 3 charts, we use this case often, same charts with same visual level filters but on different dimension. The problem we have is when you filter on any bar chart all other filter to zero, since that dimension is excluded in visual level filter on other charts.
Is there a way to override this, with some IF ISFILTERED or something like that. The case for us would be to filter on month when you click on bar chart, but on other graphs to also only filter on month, disregard the dimension and keep it as is in visual level filter on that specific chart
Hope I explained correct. I've also added a phote to see the problem we have
Thanks,
Dragan
https://www.dropbox.com/s/2a6hxwsa5pmnaf8/Test%20Report.pbix?dl=0
Select Charts > Go to Format > Click Edit Interactions > select the no impact icon - repeat this step for other charts too.
Or for better understanding read the below
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Hope it helps.
Mark it as Solution to help others looking for answers.
This is not a solution since when we filter on previous months we would like to see that specific month filtered,
Aslo we are using KPI tile on top of that and we would also like it to revert to specific month when filtered on that month.
So it would definettly need to be some change in measure to disregard this visual level filter
Thanks
for instance one case is like this, thats why we would like to fix this with DAX if possible
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |