Alignment for row and column totals

[George-Stan]

Can we get a native support to toggle which will automatically align total row and column values without emploing a dax measure or column to do this. It will be as easy as including the alignment pane in the rows and columns total as we have in the specific column. This is specific to the matrix visual.

[rohit1991 · Accepted solution]

Hi @George-Stan ,

Thank you for raising this — it's a great observation and definitely something many Power BI users would find helpful. Currently, as you've noted, there's no built-in toggle or native support to align row and column totals independently within the matrix visual. Users often resort to DAX workarounds or custom formatting, which isn't ideal for something that should be straightforward.

Adding alignment options directly in the formatting pane for totals—just as we have for specific columns—would greatly enhance usability and visual consistency, especially in more complex reports. Hopefully, this suggestion gains traction, as it's a practical improvement that aligns with Power BI's ongoing efforts to streamline and empower report design.

In the meantime, as @pankajnamekar25 mentioned, some third-party visuals like Zebra BI Tables or the ones from Infragistics offer more control over total formatting and might serve as a viable alternative depending on your needs.

[v-echaithra]

Hi @George-Stan ,

If the provided answer was helpful, please mark it as "Accept as solution" and click "Yes" if you found it helpful, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[v-echaithra]

Hi @George-Stan 

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[v-echaithra]

Hi @George-Stan ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[burakkaragoz · Accepted solution]

Hi @George-Stan ,

Yep, you can control the alignment of row and column totals in Power BI—though it’s a bit hidden in the formatting pane.

Here’s how to do it:

1. Select your visual (Matrix or Table).
2. Go to the Format pane > Specific column.
3. Choose the column you want to adjust.
4. Toggle on Apply to total (and Apply to subtotal if needed).
5. Then set the Alignment (left, center, or right) as you like.

This should align the totals the same way as your values. If it still looks off, try toggling Apply to header as well—it sometimes affects how the total row behaves.

Let me know if that works for you!

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI

[rohit1991 · Accepted solution]

Hi @George-Stan ,

Thank you for raising this — it's a great observation and definitely something many Power BI users would find helpful. Currently, as you've noted, there's no built-in toggle or native support to align row and column totals independently within the matrix visual. Users often resort to DAX workarounds or custom formatting, which isn't ideal for something that should be straightforward.

Adding alignment options directly in the formatting pane for totals—just as we have for specific columns—would greatly enhance usability and visual consistency, especially in more complex reports. Hopefully, this suggestion gains traction, as it's a practical improvement that aligns with Power BI's ongoing efforts to streamline and empower report design.

In the meantime, as @pankajnamekar25 mentioned, some third-party visuals like Zebra BI Tables or the ones from Infragistics offer more control over total formatting and might serve as a viable alternative depending on your needs.

[pankajnamekar25]

Hello @George-Stan 

You're absolutely right  Power BI currently does not offer a native alignment toggle for row and column totals in the matrix visual.

Use custom visuals from AppSource that offer enhanced matrix capabilities (e.g., Zebra BI, Infragistics, etc.) that may allow more formatting flexibility.

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.