Use Multiple Binary Columns as Separate Bars in Bar Chart

[oliverblane]

Hi. I have a table like the following:

The table shows which products customers have ordered (ID is the customer ID).

I have a bar chart like the following:

Is there any way to have the bars separated and with their labels underneath them, instead of as a cluster of bars?

Sample File: sample_file.pbix

Thanks for any help on this!

[AntonioM · Accepted solution]

You could unpivot those product columns in Power Query

That will give you a table like this

And then you can use the 'attribute' column as the axis in the bar chart

[oliverblane]

Very helpful, thank you @AntonioM!