Clustered Column Chart using Multiple Columns.

[OceanMan]

Hi All,

Having issues trying to figure this problem I have out. I have a big dataset ive imported from excel and within that dataset are the three columns below. I am struggling to list the Maps from all three columns as my axis. What I am after is a clustered column graph with each Map on the axis, and then the number of Bans that map recieved and whether it was the 1st ban, 2nd ban or third ban.

                                                                                 My Data:                                  

                                                            Where Im Stuck:

[mussaenda]

You will need to unpivot the columns so you can use them as x axis on your chart

[JosefPrakljacic · Accepted solution]

Hey OceanMan,

you need to unpivot the table in the PowerQuery Editor.

I did that for you in that example file

Here you have a Screen.Gif -> Sorry for the german version but you will get it 🙂

Please kudo & mark this post if I was able to help you

Have a nice day OceanMan!

BR,

Josef