Forum Discussion
Report with hierarchical table
Hello all,
I am trying to create a table/matrix in my Power BI report to view my data like this:
I have a data source for Brand, that contains the brand name and some explanation about the brand. Another data source for the models, and another data source for different options.
When I create a matrix with all the data, the last column is not like a big merged cell, but I see the same "Brand Detail" text in front of each "Option" line. So repeating the same text.
Does anyone know a workaround? Thank you.
Best,
Navid
6 Replies
- amitchandak
Super User
Navid_sh , I doubt you can do that in matrix.
refer if this approach can help
Power bi Excel for P&L , add in app
Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZgThank you amitchandak. Yeah, it seems to be imposible!
Hi Navid_sh ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
1. Create a matrix visual with below settings
2. Toggle off the option "Stepped layout"
Best Regards
Hi Anonymous ,
Thank you for trying to solve this problem.
This still doesnot solve the problem, the data of last column ("First Brand Detail") is repeating itself in each row. Instead I want one big cell in front of each "Brand" that contains the "Brand Detail".
Best,
Navid
