Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |