Sales vs Target Table how to change year from row to column ?

[admin11]

Hi All

I have below table :-

working fine. The year on the row.

I like to change to :-

year on column. 

Hope some one can advise me.

Paul

[jaipal · Accepted solution]

@admin11 hi, it's working.

you realy can't show Sales_ & Target_ on side as per your requiremnet.

you can't put the a measure in row level.

[admin11]

@jaipal 

Thank you 

Paul

[amitchandak]

@admin11 , Use matrix visual

Year on column ,

Measures on values

Enable Show on Rows Option

Nothing on row

[admin11]

@amitchandak 

I have follow your instruction , i still unable to make it .

My PBI sampel file :-

https://www.dropbox.com/s/cubmxiyiwxs66t4/sales%20vs%20target%20yr%20on%20column.pbix?dl=0

Hope you can take a look.

Paul

[amitchandak]

@admin11 , check if this file can help

https://www.dropbox.com/s/04udgz4mi0dgnd4/sales%20vs%20target%20yr%20on%20column.pbix?dl=0