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.
Go to Solution.
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:
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.
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!