Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I use a line chart with two different lines and additional a reference line. On the Y-axis I have no start and no end value adjusted, so the range is dynamic and depends by the values of the two lines. My problem is that the reference line is not always displayed. Depending on the values of the two lines it is possible that the reference line disappears. Currently the lowest value of my two lines is approximately 64% an the highest value is approximately 70%. My reference line has a value of 75%. My chart only shows me the range from 62% to 72% on the Y-axis. Is there a ability to fix the problem? I know it is possible to set a start and a end value for the Y-axis. But I need the dynamic range so this does not solve my problem satisfactory.
Can you add a measure which is just equal to the reference line value, and then use the measure instead? (You can also use the measure in your line chart, change the color to white so that it looks invisible and then your reference line will become visible as the dotted line)
@SqlJason Thank you for your creative ideas!
Your first idea was also my first idea. But I needed a dotted line and also the value of the reference line so this solution would be my last option.
Your second idea is principally great but the problem is that the white color would also be displayed in the legend of the line chart. So this solution is not really ideal because it could be lead to confusions.
So I hope the Power BI Team will fix the bug with the disappeared reference line in association with a dynamic Y-axis (no start and no end value) as soon as possible.
And @SqlJason I wish you good luck for the final days at the best report contest! Your report is awesome. You have my support. I voted for it.