Forum Discussion
BarryM
3 years agoHelper II
undefinedPBI matrix table formatting
Thanks in advance for any help. I am having issues recreating a matrix that I created 6 months ago. Due to major changes in the DB I had to recreate the PBI file. This is the original PBI file ...
- 3 years ago
Hi , BarryM
Thanks for your quick response !
According to your description, you want just the First Column show SubTotal and Total in the buttom.
I test it in my side , i think you can try to this .
We can create a another calcualted column like this:Column = RANKX('Table','Table'[Cost_type],,ASC,Dense)Then we can put this Column as the first of the field in Matrix's Rows.
Then we can close all the "Text wrap" in the format:
And then we can hide the first column in the visual:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
BarryM
3 years agoHelper II
This is the new matrix