Create a bar chart from Multiple Columns

Hi, I have some columns like this: Application Melbourne? Sydney? Brisbane? New York? Pacman Yes Yes Yes Pinball Yes Yes Space Invaders Yes Yes Street Fig...

Need Help

Tips and Tricks

PaulDBrown
5 years ago
Anonymous

The easiest way is to unpivot the city columns in Power Query. Select the query, select the "city" columns" and choose "unpivot columns" in the ribbon:

This will ransform the table to this structure, where you now have th cities as a column which you can use in the visuals as a field.

You can now create you visuals. For example:

Forum Discussion

Create a bar chart from Multiple Columns

Related content

Create custom column based on multiple rows

Create columns group

Sequential Order column based on multiple criteria

Creating multiple Audiences in PowerBI App

Multiple messages when new item created