The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Solved! Go to Solution.
Hi @Nicci
Please refer to my solution in the linked discussion, including a link to the pbix.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Nicci
Please refer to my solution in the linked discussion, including a link to the pbix.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |