Forum Discussion

George-Stan's avatar
George-Stan
New Member
1 year ago
Solved

Alignment for row and column totals

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 pan...
Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    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.

  • burakkaragoz's avatar
    burakkaragoz
    1 year ago

    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

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

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.