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?
Go to Solution.
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 _ JingIf this post helps, please Accept it as Solution to help other members find it.
View solution in original post
Create a measure like this:
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
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
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.