Line chart Y-Axist Constant Reference Line display 0 with blank value

[zealotworld]

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)

[ManuGP]

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?

[MFelix]

Hi @ManuGP ,

Are you able to share a sample file or 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.

Thank you.
If the information is sensitive please share it trough private message.

[MFelix]

Hi @zealotworld ,

I cannot replicate this issue on the last version of Power BI. What is the version you are using.

[zealotworld]

 Hi @MFelix , Im using version 2.119.986.0 64-bit (July 2023)

[MFelix]

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.