Forum Discussion
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.
However, I want it to be arranged like this.
Please help . Thankyou
1 Reply
- Daniel29195
Community Champion
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! 🤠
