Forum Discussion

zealotworld's avatar
zealotworld
Frequent Visitor
3 years ago

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 ...
Need Help
ManuGP's avatar
ManuGP
Advocate I
1 year ago

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's avatar
    MFelix
    Super User
    1 year ago

    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.