Use Multiple Binary Columns as Separate Bars in Bar Chart

Question

Hi. I have a table like the following:The table shows which products customers have ordered (ID is the customer ID).&nbsp;I have a bar chart like the following:&nbsp;Is there any way to have the bars separated and with their labels underneath them, instead of as a cluster of bars?&nbsp;Sample File:&nbsp;sample_file.pbix&nbsp;Thanks for any help on this!

antoniom · Accepted Answer

You could unpivot those product columns in Power QueryThat will give you a table like thisAnd then you can use the 'attribute' column as the axis in the bar chart&nbsp;

Forum Discussion

Use Multiple Binary Columns as Separate Bars in Bar Chart

2 Replies

Related content

Split a column into two separate columns

Splitting Multiple Cells consecutive columns into separate rows

Sequential Order column based on multiple criteria

Conditional formatting multiple columns in matrix separately

separate values into columns