Forum Discussion
mePrafull
3 years agoFrequent Visitor
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
- mePrafullFrequent Visitor
got a solution Using UNPIVOT at powerquery added the colum and merge them for each category, Staying Leaving etc.
- some_bihCommunity Champion
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