cancel
Showing results 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

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.

How to do this?

1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
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:

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

Resolver I

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

Community Support

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.

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.