Forum Discussion
Line chart Y-Axist Constant Reference Line display 0 with blank value
Hi,
I have created a target measure that returns Blank <> when no target applies.
When I try to use this measure with a Y-axis constant reference line chart, the Y-axis reference line shows a 0 there, which is very misleading.
I found that a similar bug was already reported in an investigation by 2021.
https://community.fabric.microsoft.com/t5/Issues/Analytics-Y-Axis-Constant-Line-bug/idi-p/2226049
Is there a solution? Im using the latest Power BI version: 2.119.986.0 64-bit (July 2023)
5 Replies
Hi zealotworld ,
I cannot replicate this issue on the last version of Power BI. What is the version you are using.
Hi MFelix , Im using version 2.119.986.0 64-bit (July 2023)
This is the latest version.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Hi zealotworld I am running into this same problem in 2025 (Version: 2.139.2054.0 64-bit (January 2025). By reading your case I'm more convinced this is a bug.
In my case it is more evident because I have 2 measures shown as reference lines in a scatterplot. Both are built very similarly:
Overall KPI = SWITCH( SELECTEDVALUE(DrilldownSelection[Selected Entity]), "dd1", [KPI Main Selection], "dd2",[KPI Main Selection], "dd3", [KPI Main Selection], BLANK() )
Overall Target = SWITCH( SELECTEDVALUE(DrilldownSelection[Selected Entity]), "dd1", [KPI Target], "dd2",[KPI Target], "dd3", [KPI Target], BLANK() )When both measures return value they are shown:
...but somehow when we are in the conditions where both lines should return BLANK one of them is effectively not shown, but the other shows as 0.
Thanks in advance
I checked everything and the settings of both reference lines are exactly the same.
Have you found out anything else since 2023?
