Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gjnr
Regular Visitor

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 prodavg
laptop46.75
desktop56.75
chairs26.75
tables166.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

 

gjnr_0-1718358337406.png

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.

 

 

 

1 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.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

lbendlin_0-1718485762872.png

 

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.

gjnr_0-1718558046253.png

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

gjnr_1-1718558109987.png

Kinldy let me know if you need more information.

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.