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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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