Forum Discussion

EstherBR's avatar
EstherBR
Helper III
10 months ago
Solved

Format Subtotal Column in Power BI

Hi,

 

I have created a Matrix with subtotals only activated for the column "Year". I would like to know how to format the column total for the Year. I cannot find any option in the "Format visual" . 

 

Thank you so much!

 

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    10 months ago

    EstherBR 

    I tried in PBI, you can set up the color separately. However, you can't set up the data type separately.

3 Replies

  • AntoineW's avatar
    AntoineW
    Super User
    10 months ago

    Hi EstherBR,

     

    In the Matrix visual, the column totals (like your “Year Total”) don’t have a separate formatting option under Format visual. They inherit formatting from the field itself.

    If you want to format them differently, you have two main options:

    1. Field formatting (per column/measure)

      • Go to Format visual → Cell elements → Values → Specific column.

      • Select your measure/column, then adjust number format, font, background, alignment, etc.

      • This applies to both the detail cells and their total/subtotal cells.

     

    Hope it can help you,

    Best regards,

    Antoine

  • EstherBR's avatar
    EstherBR
    Helper III
    10 months ago

    Hi Antoine,

    Thanks for your help AntoineW , but I couldn´t find the option in Cell elements. 

    I finally found it on 

    • Go to Format visual → Column Subtotals → Values

     

     

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    10 months ago

    EstherBR 

    I tried in PBI, you can set up the color separately. However, you can't set up the data type separately.