Forum Discussion

oliverblane's avatar
oliverblane
Helper III
4 years ago
Solved

Use Multiple Binary Columns as Separate Bars in Bar Chart

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 h...
Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

    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

     

AntonioM's avatar
AntonioM
Solution Sage
4 years ago

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