cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
khush19
Resolver I
Resolver I

How to get constant line in Line and stack chart

Hi All,

 

I have requirement where i need to add a line at 85% ( a constant line) on my line and stack chart.

khush19_0-1655423023727.png

 

How to do this?

1 ACCEPTED SOLUTION

Hi @khush19 

 

In this scenario, it doesn't support to add a y-axis constant line for the stacked columns. If you add a measure to Line y-axis area, it uses the line axis rather than the column axis.  

 

You may calculate the max value for the line axis. Then multiply 0.85 to the max value in a measure. Put this measure to the chart as a line. It will appear at the 85% height position of the column. 

vjingzhang_0-1655872964190.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

3 REPLIES 3
VahidDM
Super User
Super User

Hi @khush19 

 

Create a measure like this:

constant line = 0.85
 
and use that in the Line y-axis field of the visual like the below:
VahidDM_0-1655423592916.png

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

Badges.jpg

LinkedIn | Twitter | Blog | YouTube 

Thanks Vahid ,

 

but in My case % axis has stack chart and numbers are for line chart.

so when i add something like this it add to stack chart

 

khush19_0-1655423904674.png

 

Hi @khush19 

 

In this scenario, it doesn't support to add a y-axis constant line for the stacked columns. If you add a measure to Line y-axis area, it uses the line axis rather than the column axis.  

 

You may calculate the max value for the line axis. Then multiply 0.85 to the max value in a measure. Put this measure to the chart as a line. It will appear at the 85% height position of the column. 

vjingzhang_0-1655872964190.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors