Forum Discussion

BarryM's avatar
BarryM
Helper II
3 years ago
Solved

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 ...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
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's avatar
BarryM
Helper II
3 years ago

Thanks for your assistance, I managed to find the solution. The problem was with the changes that MS had made to the PBI formatting interface. In previous versions it was very clear where and how you needed to turn the per row subtotals on and off. In the current version we are using setting the per row level is separated into two sections that make it appear as two separate and disparate settings. I was not making the connection between the two selectors. I stumbled across these settings by happenstance while trying to implement some other solutions.