Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I am new to power bi (pbi), but I have played with power pivot (PP) before.
I want to know how to create a categorical hierarchy in pbi. My goal is to have a stacked column chart, with the date on the x-axis and the hierarchy in the legend, so I can drill down into the child categories. I can do this in PP.
In PP I can just right click on the fields and select 'create hierarchy', and then use this created field as the legend. However, I don't know how to create this hierarchy in pbi.
I am using a csv exported from YNAB (budgeting software). It has three columns that might be useful:
In PP I right-click on 'category group' and 'category' and voila, the hierarchy option is available.
Any help greatly appreciated.
Thanks.
under the table , just drag you column and drop on 2nd column and it will create hierarchary. keep on dropping more field on to this and fields will get added to hierarchary.
Once it is create, you can move the fields with hierarchary and remove from it.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks, that helps me how to create a hierarchy.
However, when I place this hierarchy field in the 'legend' spot (in a stacked column chart), only the parent level goes across. Is there a way to take all levels of a hierarchy into a legend field so that I can drill down via legend?
Thanks.
Hi @atlasB,
You can right click on that column and choose hierarchy mode if it available.
Regards,
Xiaoxin Sheng