Matrix alignment issue

[han_rj]

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 · Accepted solution]

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]

Hi @han_rj,

I would also take a moment to thank @Alex_Sawdo  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Thank you

Harshitha.

Community Support Team.

[v-hjannapu]

Hi @han_rj,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Thank you.

Harshitha.

Community Support Team.

[v-hjannapu]

Hi @han_rj,

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Harshitha.

Community Support Team.

[han_rj]

I have a matrix like this

 I want to center aligin the word "Total" and have Categoried aligned middle of each cell

[v-hjannapu · Accepted solution]

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

[han_rj]

Apologies for the delayed response , No I did not receive the solution yet. The solution given is different from the case I need help

[Alex_Sawdo]

I believe the option you'd be looking for is found at this path: 
Visualizations Pane->Row Headers->Text->Alignment

Here's what that looks like with some sample data: 

The total center align should be under this path as well: 
Visualizations Pane->Specific Column->{{Your Value Series}}->Check "Apply to total"->Values->Alignment

[han_rj]

No I do not want the Totals in between values, Want the Total to be at the last and I want the Total Word center aligned

[Alex_Sawdo · Accepted solution]

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.