Nested column layout in a Power BI Matrix visual

[heranaval]

How can I create a nested column layout in a Power BI Matrix visual with the following data structure?

I have the following data:

I want to create a matrix where:

• The rows are based on the "Code" column.
• The columns are nested by:
  • Year (e.g., 2024),
  • Month (e.g., Jan, Feb, etc.),
  • Category (e.g., BTQ and DS) with nested columns for Price, Quantity, Amount (Price * Quantity), and Type.

The final layout should look like this:

Can anyone help me to achieve this layout? Thank you!

[Ritaf1983 · Accepted solution]

Hi @heranaval 
Since in Power BI, the matrix is structured and does not allow for individual cell customization or merging options, the closest representation to what you provided in the image would be a tabular layout, with the category placed at the beginning, as shown in the image.

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[danextian · Accepted solution]

Hi @heranaval 

While the layout is fairly simple without the extra Type column, adding it complicates things. You'll need a disconnected table that includes all the necessary column and row combinations. Additionally, you should have a column for the dynamic format string (please search how to set this up) since those values will be formatted differently. Lastly, you'll need a measure that returns the correct values based on the row/column combinations. Also, it not possible to merge headers vertically such as the one above code and after Feb.  This is the closest I could get to - any more than this and you're looking into a premium custom viz like the matrix from inforiver .

Please refer to the attached pbix.

[Anonymous · Accepted solution]

Hi @heranaval ,

Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.

If not, please provide a more detailed description, preferably some more virtual sample data, and the expected results.

Best Regards,

Stephen Tao

[danextian · Accepted solution]

Hi @heranaval 

While the layout is fairly simple without the extra Type column, adding it complicates things. You'll need a disconnected table that includes all the necessary column and row combinations. Additionally, you should have a column for the dynamic format string (please search how to set this up) since those values will be formatted differently. Lastly, you'll need a measure that returns the correct values based on the row/column combinations. Also, it not possible to merge headers vertically such as the one above code and after Feb.  This is the closest I could get to - any more than this and you're looking into a premium custom viz like the matrix from inforiver .

Please refer to the attached pbix.

[heranaval]

Thank you for your help!

[Ritaf1983 · Accepted solution]

Hi @heranaval 
Since in Power BI, the matrix is structured and does not allow for individual cell customization or merging options, the closest representation to what you provided in the image would be a tabular layout, with the category placed at the beginning, as shown in the image.

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[heranaval]

Thank you for your help!