Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi - I have a report from which the user can select the geography that they wish to view data for. They need to be filters as there are too many layers to accomodate slicers on the report pages.
I need to show on a report page what has been selected from the lowest level of geography at any point in time. The heirarchy (in order) is:
Country
Macro Organisation
Decision Making Cluster
Account
Cluster
So if someone selects a / multiple cluster in the 'Cluster' filter, I want the measure to show the cluster name(s). However if they don't select a cluster but have selected an / multiple accounts it should show the account name.
Any idea where to start
Solved! Go to Solution.
HI @lewdow,
You can refer to the following link to know how to handle hierarchy level fields, then you can add if statement with filters to check current hierarchy level and return correspond selected items.
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng
HI @lewdow,
You can refer to the following link to know how to handle hierarchy level fields, then you can add if statement with filters to check current hierarchy level and return correspond selected items.
Clever Hierarchy Handling in DAX
Regards,
Xiaoxin Sheng
Just noticed the Hierarchy slicer/filter released today as a preview version - Feb 2020. Thats exactly what you need.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/
User | Count |
---|---|
84 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |