Forum Discussion
I need help to create custom background format in line barchart according to the values of Y-axis
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.
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.
3 Replies
- lbendlin
Super User
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
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.
