Forum Discussion
Collapsible (categorized) table in power BI
I am relatively new to Power BI, but a long time user of Lotus Notes. I have an application in Lotus IBM HCL Notes that I would like to migrate to Power BI.
I have hierarchical data Business Unit, Customer, Order No (rev and cost) and I want to allow users to see all the data categorized by Business Unit collapsed and then be able to drill down in a specific BU to see all customers and then to drill down in specific customers to see the various orders. I have played with group by and rollup in SQL and can get the tables any way I want them, however I can't seem to figure out how to get the display I'm looking for. I want to use the Table visualization (at least I want the data to display - whether or not the Table visualization is the right one, I don't know).
Any help or direction is greatly appreciated.
Refer, if this can help
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
Hisbodell,
It seems that you want to drill down level, right? If so I think you could try to use Matrix in PowerBI, you could refer to Use the Matrix visual in Power BI for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Refer, if this can help
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
- dax
Community Support
Hisbodell,
It seems that you want to drill down level, right? If so I think you could try to use Matrix in PowerBI, you could refer to Use the Matrix visual in Power BI for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.