Forum Discussion

mePrafull's avatar
mePrafull
Frequent Visitor
3 years ago
Solved

Need help with DAX - Power BI Matrix visual

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.

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

4 Replies