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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Is it possible to have a 'zoned' line chart (example within)

Hi I am looking for a visual that will give me something like this:

 

Screenshot 2020-10-23 at 17.59.16.png

I have an individual's height and BMI The chart above is taken from a piece of software that then plots the weight measurements (easy enough), but I would like to have the BMI zones displayed within the chart, like above. Does anyone have any idea how, or if this is possible with PBI?

 

Thanks

3 REPLIES 3
v-yiruan-msft
Community Support
Community Support

Hi @Anonymous ,

Currently Power BI only support conditional formatting applies to the values of Table or Matrix visuals, so it is not able to have conditional formatting background color for line chart. You can find the details in this offical documentation. You can raise a new idea and add your comments there to make this feature coming sooner.

In addition, I create a sample pbix using line chart and shapes to create a similar visual. Please check whether that can be used as an alternative.

zoned line chart.JPG

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi. I have tried to replicate this but cannot get my head round it. Could you please send the .pbix? The link has been removed.

amitchandak
Super User
Super User

@Anonymous , you can have a secondary y-axis. But that can not be used unless there is a measure that uses that.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-customize-x-axis-and-y-axis#customizing-visualizations-with-dual-y-axes

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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