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.
Hello every body,
We have an issue, in one of the visuals (Visual #1) we have a count of product filter by category 1 and 2, and in the other visuals they have the count of product of all the categories, the problem is when interacting with visual #1, the other visuals total changes to a count of product by fitlering to category 1,2. We already try "calculate" with "all" function, but it's not working, the only thing I can think of is to cancel the interaction, but we do want the report to be dynamic.
Any help on how to resolve this will be much appreciated.
Example filter with slicer.
Example filter with interaction of visual #1.
Solved! Go to Solution.
hi, @Anonymous
I think if "Total of product, category1,2 bar chart" is filtered category1,2 by visual level filter.
So when you do interaction, it will also interact with other visual by setting in visual level filter.
And you could try to use a measure like this:
If not your case, please share your simple sample pbix file.
Best Regards,
Lin
hi, @Anonymous
I think if "Total of product, category1,2 bar chart" is filtered category1,2 by visual level filter.
So when you do interaction, it will also interact with other visual by setting in visual level filter.
And you could try to use a measure like this:
If not your case, please share your simple sample pbix file.
Best Regards,
Lin
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 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |