Stop Power BI from interpolating between missing values

[marvir]

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!

 

[Anonymous · Accepted solution]

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

[Rupak_bi]

Hi @marvir ,

Power BI by default skip blanks and doesn't interpolate. However, if happening so, why don't you put a filter on the data and uncheck blanks. Am I missing something??