Visualization of missing data points in chart

[tuncay]

Is it possible to connect two data points in a table even though there is no data between? See green graph line.

The connection appears only when the data points are next to each other.

[Idrissshatila]

Hello @tuncay ,

try to replace blank with zero in the measure calculation.

like if measure is blank then 0 else measure.

[tuncay]

but I want to connect them that the data point goes directly to the other and not to 0 in between

[Idrissshatila]

but this would be inaccurate, this would mean that there was data on this level and there wasn't, isn't this misleading ?

[tuncay]

it would not, it would just connect the data points with each other

[v-linyulu-msft]

Thanks for the reply from Idrissshatila , please allow me to provide another insight:

Hi, @tuncay 

Regarding your query, besides using the method of replacing metrics, another approach we can think of is to change the type of the x-axis of the visual object to continuous, as shown in the settings:

Here is the setup before modification:

Here is the setup after modification:

Below is the relevant documentation which we hope will be helpful to you:

Solved: what do the continuous and categorical type option... - Microsoft Fabric Community

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tuncay]

Then I have the following problem, that it cuts off some days from the X-axis. I already tried to adjust the spacing etc. but that did not help.. I want to see every day in the X-axis.

[v-linyulu-msft]

Hi,@tuncay 

Your idea is great.

Nevertheless, according to our measured results, I feel regretful to inform you that it turns out to be a by-design one.

If you feel that performance needs to be improved, you can also submit an idea on

https://ideas.fabric.microsoft.com/ and wait for users with the same needs as you to vote for you and help you realize the idea as soon as possible. Many features of our current products are designed and upgraded bed on customers’ feedback.  With requirements like this increase, the problem may well be released in the future.

Thanks for your understanding.You can consider accepting my reply as a solution, which will allow more people with similar issues to you to find the post more quickly and vote for your idea.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.