Forum Discussion
Stop Power BI from interpolating between missing values
Hi,
The whole point of my graph is to show where data points are missing, but Power BI keeps filling the blanks by interpolating between them:
I would like the points to just disappear wherever there's a blank value.
The graph uses the following data:
where "time" is a "Time" format and "Actual_value" is a General format.
Thanks in advance to anyone who can help!
Hi marvir ,
Is that Scatter chart? According to my test, it doesn't support show blank value as blank, but you can show blank value as 0. You can also set a color style to highlight blank values.
——————————————————————————————————————————————————
If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.
Best regards,
Mengmeng Li
2 Replies
Hi marvir ,
Is that Scatter chart? According to my test, it doesn't support show blank value as blank, but you can show blank value as 0. You can also set a color style to highlight blank values.
——————————————————————————————————————————————————
If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.
Best regards,
Mengmeng Li
