How do I make a Multi-column matrix

[AndreasRom]

Hello everyone, 

I have previously asked a question about customizing a matrix to be used in a Power BI report, where I recieved some really useful answers. I have now run into a new matrix problem, that I hope someone can help me figure out.

The following table is an example of what I am looking for and additonal/other columns could be added.

When I try to add the "location informations" it looks fine, but as soon as I also add the values of the months to be calculated, the matrix will change. 

Thank you for taking your time reading through my post 🙂

[v-jianboli-msft · Accepted solution]

Hi @AndreasRom ,

Based on your description, I have created a simple sample:

Please try:

Turn on Row Subtotals, then turn off Show Subtotal for all the rows except Location Number

Final output:

Best Regards,

Jianbo Li

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

[AndreasRom]

Hi Jianbo, 

This was exactly what I was looking for! Thank you so much! 😄 

[amitchandak]

@AndreasRom , what is the problem is not clear. If the month is joined with a table or part of the table and used in the column as a field it should work

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.