Visualization of a multiple choices list in a bar chart

[ffirda99]

Hi everyone,

I have sharepoint list column like this,

The column type is multiple-choice. I want to visualization that value (crack, oversize, spatter, undersize, underfill) in bar chart. But when I drag the data to X axis, the value doesn't appear. So it like this:

How to solve this problem? Thank you in advance.

[Ritaf1983 · Accepted solution]

Hi again @ffirda99 🙂
You have to make some manipulation on power query to convert it to "practical table" to work with:

Link to file with a solution: Link 

1. Filter out blank rows:

2. Promote heathers (if it didn't happen automatically on import)

3. Split your column by delimiter (",")

4. Transpose the result:

5.Unpivot columns

6. Rename column of your values:

7. Remove column "Attribute"

8. Count defects within the group by 

9. Close and apply 

10. Put it on any visualization you need:

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

[ffirda99]

Hi @Ritaf1983 

Thankyou!! it can work, have a nice day!

[Ritaf1983]

Happy to help 🙂
🙂

[Ritaf1983]

Hi @ffirda99 
Sorry, I couldn't figure out how the data was imported into Power BI's dataset.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[ffirda99]

Hi @Ritaf1983 

This is my table, column type from this table is multiple choice (SharePoint list)

Type of Defect

Crack, Oversize

Spatter

Undersize, Underfill