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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
nemo189
Frequent Visitor

Arranging and customization in matrix

I Have a problem I am unable to solve in matrix visual.
I added two values in the value fields ( No. of invoices and Total value). 1 value in the column field (days over due).

I am getting this in power bi matrix visual.

nemo189_0-1708974468712.png

However, I want it to be arranged like this.

nemo189_1-1708974506326.png

Please help . Thankyou 

1 REPLY 1
Daniel29195
Super User
Super User

@nemo189 

when you add a column to the matrix, power bi will calculate each value added to the matrix per the values of the column added. 

in order to achieve what you want, you need to remove the column field, and create like 6 measures ( in your case ) , and drag them in the order you want . 

 

m1 -->  181 -365 days overdue nb of invoices on hold

m2 -->  365 + overdue nb of invoices on hold 

m3 -- total 

m4 -->  .. 

m5  --> ...

m6 --> total

 

 

hope this helps .

 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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.

Top Solution Authors
Top Kudoed Authors