Pivot Row To Column.

[it_akasjraj]

Hi Community,

I need your support in one of my query. Please help me out on this....Thanks in advance.

This is what i have.

And the below is the requirement...which i have to show in power bi

@Anonymous

[amitchandak]

@it_akasjraj , You can use matrix visual for that

GL head, store on row

Month on column

Paid and book on values 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[it_akasjraj]

Sir, i tried with Matrix Visual also...but the problem is, "GL Head" and "Store Name" column comes with + symbol... but i have to display both seperatly...like i attache the excel image in last message.

[Anonymous · Accepted solution]

Hi @it_akasjraj ,

You can follow the below steps to get it, later check whether that is what you want...

1. Create a matrix visual and set it as below screenshot

2. Toggle off the option "Stepped Layout" under the menu "Row headers"

Best Regards