Forum Discussion

khush19's avatar
khush19
Resolver I
4 years ago
Solved

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.   How to do this?
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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. 

     

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

VahidDM's avatar
VahidDM
Super User
4 years ago

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:

 

 

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

  • khush19's avatar
    khush19
    Resolver I
    4 years ago

    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

     

     

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      4 years ago

      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. 

       

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