different matrix display

[KevinSV]

Hello, i'm opening this forum about a question I have about the matrix in Power BI desktop. 
Actually I have this matrix : 

I'd like to change the matrix display like this : 

Do you know if it is possible in Power BI Desktop or not ? 
Because when i try to put the Tabular Layout (layout and style presets in the visual option), I have no access to the amount because i have a lot of column (but i need all of them) :

when i use the scroll bar the columns are fix and just the amount are scrolling but as you can see on the screen i can't see them. 

Thanks 🙂 

[DataNinja777 · Accepted solution]

Hi @KevinSV ,

In Power BI, adjusting the Matrix visual to display data differently requires modifying its layout and formatting settings. First, try disabling the Stepped Layout option in the Format pane under Row headers. This flattens the hierarchy, aligning all row levels instead of nesting them. Another option is to enable Tabular Layout within the Layout and Style Presets, which provides a more structured display without indentation.

If the issue persists due to fixed column widths preventing the amounts from being visible, consider manually adjusting the column widths by dragging the dividers. Enabling Word Wrap in the Column Headers section can also help fit more data within the visible space. When scrolling causes columns to remain fixed while amounts move out of view, resizing or reducing the number of visible fields can mitigate the issue.

For a more flexible approach, you might want to pivot your data in Power Query. If necessary, using a DAX measure can dynamically adjust the totals while ensuring visibility in the Matrix. Here’s an example of a DAX measure that calculates total amounts dynamically:

Total Amount = 
SUMX(
    VALUES('Table'[Category]),
    CALCULATE(SUM('Table'[Amount]))
)

This measure ensures that amounts are aggregated correctly while maintaining the hierarchical structure. If you need to dynamically adjust column widths based on content, Power BI does not support auto-sizing columns in a Matrix, but pre-processing data in Power Query to normalize column lengths can help. If you'd like a more advanced approach, let me know if you need help with restructuring your data in Power Query.

Best regards,