Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys, I have a column with data from Azure table storage which is the full path of a hierarchical list from an application. The format is as follows: Organization#.#Department#.#Subdepartment (E.g. Operations#.#Projects#.#Project A)
My question is how can I convert this to a hierarchy (to be used in a slicer or for other purposes in my report).
I can do this with group, but that is manual work and needs to be updated for every new value, not very practical.
Stian
Solved! Go to Solution.
Sorted it out myself by using the "Split column" functionality to separate the hierarchy in to three columns (after the number of levels in the hierarchy, and then combined them in a Power BI hierarchy afterwards. Worked great :-).
Sorted it out myself by using the "Split column" functionality to separate the hierarchy in to three columns (after the number of levels in the hierarchy, and then combined them in a Power BI hierarchy afterwards. Worked great :-).
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |