Help please

[KateDANI]

Hello

After help please, I have created the below graph, but now I want each bar to show the breakdown in colours (red, amber, green) of what amount in £ is made up by margin below 8%, what amount in £ is made up from margin between 9-15% an what amount in £ is above 15%. In my data I have the margin percentages, please see below. 

Can anyone help please

thanks

[Anonymous · Accepted solution]

Hi @KateDANI 

You can consider the following solution.

1.Create  a type columnin the table.

Type =
SWITCH (
    TRUE (),
    [Margin%] < 0.08, "0-8%",
    [Margin%] >= 0.08
        && [Margin%] < 0.15, "8%-15%",
    [Margin%] >= 0.15, ">=15%"
)

2.Then put the type column to the legend in the visual

Then you can set the color to the column in Columns.

Set the red color to the "0-8" and set the related color in other type.

Output

Best Regards!

Yolo Zhu

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