Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.

2 Replies