Forum Discussion

Newt98's avatar
Newt98
Frequent Visitor
8 years ago

How to use a formula in SubTotal in PowerBI Matrix

Hi,   I have requirement where I need to show a calculated field like TA% from the below screenshot, which is Actual/Target. The requierment is to show the data as below.    The problem I am faci...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

You can hide the columns in the Matrix visual just reduce the size of the column:

 

 

Beware that you problably need to make some adjustments on the owrd wrap and auto-size optionf for row headers, columns headers and values.

 

Regards,

MFelix

Newt98's avatar
Newt98
Frequent Visitor
8 years ago

Thanks for this MFelix, but this is giving me alignment issues and the headers above are not aligned with the rest of the table.

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago

    Hi Newt98,

     

    cannot replicate your error when adding levels to the columns and reduce size of columns all my headings are correct, can you post a picture please.

     

    Are you messing around with word wrap and auto size in row, columns and values, your problem may be with that, one of this features may be on or off and impacting the end result.

     

    Regards

    MFelix