Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Here is how my matrix looks
with total and percent being values and payment column in rows
How to bring my values column into rows like this
can someone help with this, how it can be done
@PaulDBrownyour help would be greatly appreciated if possible
Thank you
Solved! Go to Solution.
If your "Total" and "percent" are measures, it should be as simple as turning on the option to show values on rows. You will find it under "Values"/ Options in the formatting pane.
(Apologies since I cannot post images since I seem to have exceeded my limit)...
Proud to be a Super User!
Paul on Linkedin.
If your "Total" and "percent" are measures, it should be as simple as turning on the option to show values on rows. You will find it under "Values"/ Options in the formatting pane.
(Apologies since I cannot post images since I seem to have exceeded my limit)...
Proud to be a Super User!
Paul on Linkedin.
thank you 🙂 it helped
you have helped in many use cases without you i would have been stuck many times.
Please create new account 🙂 your gifs are really helpful
Hi @Evanooruvan
You say that is what your matrix looks like.
Can you show what your source data looks like?
the data is what looks like in screenshot, values has numbers
@Evanooruvan Strikes me as a custom matrix hierarchy problem. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community
is there any other option without add on please
| User | Count |
|---|---|
| 22 | |
| 18 | |
| 17 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 60 | |
| 54 | |
| 47 | |
| 42 | |
| 37 |