Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 37 | |
| 31 | |
| 27 | |
| 27 |