Indentation in matrix for measures

[powerbiuser444]

Hello all,

I'm trying to figure out how to add indentation to my rows (which are measures) in the matrix or ideally +/- button for better visualization. Is it possible to achieve? Please help

This is the link to pbix 

https://7xinc-my.sharepoint.com/:u:/g/personal/powerbi_admin_7xpowered_com/Ec28ESW2J6xNk8Q9mEwiZasBP...

[powerbiuser444]

Hi @FarhanAhmed , thank you for the quick reply. I was trying to follow you but couldn't figure it out. Could you achieve the same in my pbix file? It's a pretty simple file

[FarhanAhmed · Accepted solution]

See if this works for you, 

The customer may have extra expand but that's how close I came up with 😞

[FarhanAhmed]

One way to do this is to create a separate table that will hold your measure name in it.

After that create a measure that will return values against each table value

_ Value = IF(HASONEVALUE('Measure Table'[M_Table]),SWITCH(FIRSTNONBLANK('Measure Table'[M_Table],'Measure Table'[M_Table]), "Sales", SUM(Sales[Sales]), "GOLY",FORMAT([GOLY],"Percent"),"Ach",FORMAT([Achievement],"Percent")),"")

then Put your fields in Rows and this one below your row field

you will get these results.