Martix formating

[Thimios]

Hi all.

I would greatly appreciate your creative ideas on how to get from 1st matrix layout which I already built, to the 2nd one.

Note that % is the same field formatted to show as % of Sales total.

[Thimios]

Thank you @Rupak_bi , so simple yet so blind....

[Rupak_bi · Accepted solution]

hi @Thimios ,

you can aschive this following below steps:

1. select the Matrix

2. go to format visual

3. Go to Value section> go to the bottom where you will find "Option" " Switch value to rows".

4. switch it on.

My PBI virsion is a bit old. for newer virsion, the location may be different but the trick is same. cheers....