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.
My report can be filtered at multiple levels, similar to the setup shown. I want to use a table visual to compare the regions - but if we drill into a region, than we use the table visual to compare stores.
Is the effect possible? My alternative would be to use buttons and bookmarks, but I'd prefer the interaction to be seemless.
Example of what effect I want to achieve:
@State Level
@Region Level
Solved! Go to Solution.
@MPetramalo214 , You can use isinscope , isfiltered or hasonevalue to check and changes measure
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
But if you have change axis/group by, you need to use bookmarks
@MPetramalo214 , You can use isinscope , isfiltered or hasonevalue to check and changes measure
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
But if you have change axis/group by, you need to use bookmarks
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |