reference line doesn't correct

[MP_123]

hi, please see the attached.

reference line show data although it has blank values (both columns & line)

is someone encountered this issue?

thanks!

[Eric_Zhang]

@MP_123

One workaround is to treat the blank values as 0. change a measure like

totalamt = IF(ISBLANK(SUM(table[amt]) ),0, SUM(table[amt]))

In my personal opinion, showing 0 is more reasonable than a gap in a line when the values are blank.

[KGrice]

@Eric_Zhang I agree, though it requires caution when your dataset has actual 0 values in it. If this isn't the case, I think plotting 0s looks much better and is less misleading than the line going straight across your data.

@MP_123, there are a couple other options outlined in the link above, but they all have their downsides. Hopefully there's one that works for your data.

[MP_123]

@KGrice@Eric_Zhang

thank you!

actually, my data source is SSAS in Live connection so the solutions don't work for me.

[KGrice]

@MP_123

Maybe for my own learning, can I ask why the solutions won't work with an SSAS live connection? I don't have any exposure to SSAS yet. If you have an original column of Score, can you not add a new measure that sets the Score to 0 when there is no data?

[KGrice]

Hi @MP_123. I think this was addressed in another topic: Line graph draws line even when there's no data. (Edit: There are a few options for workarounds there.)

There are a few options there on how to deal with this, though none of them are really ideal. If this is important, please vote on the idea here to help it gain more visibility!