Forum Discussion
Helper IIMatrix like Excel in Power BI ?
hello everyone and happy new year ! Hope you have a great rest 🙂
I have a question about the matrix. Is that possible to do the same table as the screen i send you but on Power BI ?
 
 
I add the details for the first line but they are hidding for the rest because too long for the screen. (This table is from an Excel create by MyReport)
So is that possible to do the same type of table on Power BI (maybe with the matrix visual but i don't have the same table as i want).
Do someone has an idea or tips please ?
Thank you 🙂
Thanks for the reply from MFelix, please allow me to add some more information.
Hi KevinSV ,
The feature you are referring to is the row subtotal in Matrix Visual.
Sets the layout of the matrix to tabular.
Go to the Row subtotals in the formatting settings of the matrix.
Then set up custom row subtotal labels for each row.
You can refer to the sample PBIX file.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- MFelix
Super User
Hi KevinSV ,
The option you are showing on the image is the subtotals on the excel page, has you refer this can be made using the matrix visual check the link below about the tabular features for that purpose.
https://www.linkedin.com/pulse/new-power-bi-matrix-layouts-pbicorevisuals-cr1if
Thanks for the reply from MFelix, please allow me to add some more information.
Hi KevinSV ,
The feature you are referring to is the row subtotal in Matrix Visual.
Sets the layout of the matrix to tabular.
Go to the Row subtotals in the formatting settings of the matrix.
Then set up custom row subtotal labels for each row.
You can refer to the sample PBIX file.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KevinSVHello Anonymous, thank you for the tips, it was exactly what i wanted 🙂
Have a great day !
