Forum Discussion
Changin Matrix Layout
I have created a matrix where my columns are "Cantidad" and " Costo" that are clustered by "Periodo". Periodo is a feature whereas Costo and Cantidad are measures and therefore I have place them in values. I wish I could display all Costo as 1 big group with Periodo as a lower level and next to it, Cantidad, so to say it short change the columns hierarchy considering that the lower current level are measures.
I hope I have made it clear
- This can be done easily in Excel, but I don't know a way in Power BI - you can check custom visuals as they might have a solution or vote for it in ideas: https://ideas.powerbi.com/
What you can do, is create a calculated table that contains an [Attribute] column for 'Cantidad' and 'Costo' and a [Value] column for the values. Depending on your raw data setup there are various ways to do this, either with M or DAX.
1 Reply
- AllisonKennedy
Community Champion
This can be done easily in Excel, but I don't know a way in Power BI - you can check custom visuals as they might have a solution or vote for it in ideas: https://ideas.powerbi.com/
What you can do, is create a calculated table that contains an [Attribute] column for 'Cantidad' and 'Costo' and a [Value] column for the values. Depending on your raw data setup there are various ways to do this, either with M or DAX.