Average Line with "Show items with no data"

[ricardocamargos]

Hi there,

Has anyone faced a situation like this ?? :

I have a average line from Analytics pane, also I selected the option "Show items with no data". The average value is not considering 7 months, just 6.

Thank you,

Ricardo

[v-jiascu-msft · Accepted solution]

Hi @ricardocamargos,

Yes, I reproduced your situation. I think this has nothing to do with right or wrong. It's something about how the average line is designed. There could be a workaround.

1. Replace the null value with 0 in the data table.

2. Or modify the measure like this:

Measure =
VAR MValue = SUM ( Table1[Column2] ) RETURN IF ( ISBLANK ( MValue ), 0, MValue )

3. If you want the Analysis lines work in another way, please submit or vote an idea here: https://ideas.powerbi.com.

Best Regards!

Dale