Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
Solved! Go to 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.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
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
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.