Bug constant line settings disappear when measure return blank()

[andhiii079845]

Hi,

perhaps i find a Bug in Power BI Desktop:

I have following measure:

Measure 2 =

IF(HASONEFILTER('Table'[year]),10,BLANK())

I use it in my bar chart as a constant line:

If a year is selected, i see the settings of the line in the bar chart:

If no year is selected, no setting are visiable in the bar chart:

[andhiii079845]

This will work, but i want blank () 😉

[Padycosmos]

Constantline, as I understand,accepts only numeric values. so really wonder whether that would be possible

[andhiii079845]

But in my case I like it. Only show the line if there is a value. Zero will be wrong.

[Padycosmos]

This works

IF(HASONEVALUE('Table'[year]),10,"")

[Padycosmos · Accepted solution]

This works

IF(HASONEVALUE('Table'[year]),10,"")

[andhiii079845]

Everytime very interesting. "" instead of BLANK() work! Big thanks!

[Padycosmos]

Can you please try the following

Measure 2 =

IF(HASONEVALUE('Table'[year]),10,BLANK()

[andhiii079845]

Thank you for your reply. I test it, same problem.

[Padycosmos]

The other option I can think of is IF(HASONEVALUE('Table'[year]),10,0)