I need help to create custom background format in line barchart according to the values of Y-axis

[gjnr]

Hello Everyone,

I am trying to create the barchart with following table.

name	no of prod	avg
laptop	4	6.75
desktop	5	6.75
chairs	2	6.75
tables	16	6.75

Now i need to create barchart with line(average of products) and background(not the bars) of the chart should format according to the below colour format.

if products is <= 3 then green

if products is > 3 and <= 5 then yellow

if products is > 5 then red

I have created this graph in excel for your reference.

In the graph background based on y axis values i need to colour the background in powerbi.

Kindly let me know if you need more information.

Thank you.

[lbendlin]

[gjnr]

Hello @lbendlin,

Thanks for your reply.
if i tried as suggested by i am able to see only one colour(but i need to display three diffrent colours on the background).Please see the below image for the same.

Even i tried by changing the values and still see the same.

Kinldy let me know if you need more information.

[lbendlin · Accepted solution]

ah, that's not a background. That are Y axis constant lines. Those are not available for your visual.  Consider using a custom visual like Deneb that allows you to layer multiple charts on top of each other.