Matrix table formating

[Anonymous]

Hi,

I'm working on a horizontal matrix that has months as column headers and measurements as row headers and values.

	Jan	Feb	Mar	...	Dec
New Sales	...	...	...	...	...
Renewals	..	...	...	...	...

Each row of the table is a measurement. I need to create a hierarchy between measurements, and from what I've managed to investigate this is not possible. So I was wondering if there is a way to play around with the matrix formatting such as I could replicate the illusion of a hierarchy.

Thanks.

[edhans]

Can you mock up what you want to look like in Excel and post that image? All I see above is a bunch of dots, and I am not seeing how that is a hierarchy.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

[Anonymous]

This is how I currently have the matrix set up:

And this is how I want it to look like:

All the rows are measures, so I was wondering if there is a way to align each row header individually?

Thanks.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Maybe my sample file can provide you with inspiration.

Best regards,
Lionel Chen

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