Forum Discussion

han_rj's avatar
han_rj
Helper IV
1 year ago
Solved

Matrix alignment issue

  Hi All,   May I please know if there is a way that we can center align , the Total in Matrix visualization in Power BI. And I also want the category names in the center of the cell.  
  • Alex_Sawdo's avatar
    Alex_Sawdo
    1 year ago

    Try this path as well then:
    Visualizations Pane->Row Subtotals->Per row level (ON)->Subcategory as the Row Level->Show subtotal (OFF).

    The subtotals will be off, and the main total will remain. 

  • v-hjannapu's avatar
    v-hjannapu
    1 year ago

    Hi han_rj,

    To center the Category and Subcategory values:

    • Select the Matrix visual.
    • In the Visualizations Pane, go to:

    Format pane → Row headers → Text alignment → Horizontal → Center

    To center the grand total row value and label:

    • Go to the Values formatting section:

    Format pane → Values → Alignment → Center

    • Ensure you toggle ON:
      • Apply to total

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  
    If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

    Best Regards,
    Harshitha.
    Community Support Team