Need help with DAX - Power BI Matrix visual

[mePrafull]

Hi There,

I have a requirement, i have to transform a tabular information to below output format.

What i have done is

• created measured for financial measure Revenue, Volume and cost for each category i.e. volume staying, volume exiting and volume by OTHERS
• Used SWITCH measure to have category into columns and financial measure into rows
• UNPIVOT i cannot do as as more than 5Millon rows are there
• WIth exisitng setup it was taking more time to load the viusal as there are around 22 financial measures

Thank you for checking this post.

[mePrafull · Accepted solution]

got a solution Using UNPIVOT at powerquery added the colum and merge them for each category, Staying Leaving etc.

[some_bih]

Hi @mePrafull you need to show values in rows. Check link as example

https://www.selectdistinct.co.uk/2023/02/27/show-values-in-rows-in-power-bi/ 

Did I answer correct? Kudos aporeciate / accept solution

[mePrafull]

@some_bih : THank you for reply
the suggested method will transform financial measure (i.e. Volume, revenue and cost) to rows but the distributory category will remain as it is (i.e. Staying, leaving, OTHERS)

[some_bih]

Hi @mePrafull put some of non-financial data into columns in matrix.