Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
See if this works for you,
The customer may have extra expand but that's how close I came up with 😞
Proud to be a Super User!
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
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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |