Forum Discussion
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.
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.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 itBest Regards,
Harshitha.
Community Support Team
9 Replies
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->AlignmentNo 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
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.
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.
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.
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.
