Sharepoint choices column and Power BI charts

[Nicci]

Hi All,

I am using a sharepoint list and have a choices column with a bunch of options like 'Oil Change, Car Wash, Maintenance', etc. for car stuff that people enter the date of service and select multiple service types in the drop down.

When I import into Power Bi that column comes over as 'List'. What do I do to essentially get a bar chart created to do basic counts like 'how many oil changes were there in a month vs car wash' even if 1 service has both they should be counted in both graph bars.

thank you!

[Ritaf1983 · Accepted solution]

Hi @Nicci 

Please refer to my solution in the linked discussion, including a link to the pbix.

https://community.fabric.microsoft.com/t5/Desktop/Visualization-of-a-multiple-choices-list-in-a-bar-...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Nicci]

This did help as when I was in the transform data screen and went to convert the column I found that there was only one option for the list column which was to seperate them as rows. As soon as I did that it created a row for each multi-select option that was in there and the IDs were duplicated to then group them if needed. It did exactly what I needed from there! Thank you!