Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Evanooruvan
Helper II
Helper II

Convert value column/measure in matrix into rows so it splits rows wise

Evanooruvan_0-1698422449728.png

thank you 🙂 any help appreciated

1 REPLY 1
audreygerred
Super User
Super User

Hello! Go to formatting for that visual, expand Values section, Expand Options section, then toggle 'Switch values to rows rather than columns' to On. Also, I suggest making an explicit measure for total rather than utilizing an implicit measure.

audreygerred_0-1698504360430.png

 Here is a matrix with the values in columns like default:

audreygerred_1-1698504383580.png

 

Here is it in rows:

 

audreygerred_3-1698504383644.png

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.