Forum Discussion
Create a bar chart from Multiple Columns
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:
Community ChampionAnonymous
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:
Hi Paul,
Thanks for this. Is there any way to do this with the second table? I use a lot of fields that contain multiple values from "label-type inputs".
- Ashish_Mathur
Super User
Hi,
In the query editor, rIght click on the heading of the second table and click on Split by delimiter. Select the delimiter as ; and under Advanced options, select split by rows. Click on Close and Apply.
