converting multiple columns to rows

Hi haniizz ,

After loading your data, click Transform Data to open the Power Query Editor.

Then CTRL+Click to select all of the color columns and click Unpivot Columns.

Click Close & Apply to close the Power Query Editor.

The next step is not strictly necessary, but click "New Measure" and create a measure like below (adjust for your table and column names)

SumValue = SUM(Colors[Value])

 

Then add a clustered column chart like below

 

The chart will look something like this:

 

Please accept as solution if you think this has answered the question.