Forum Discussion
Visualization of missing data points in chart
Hello tuncay ,
try to replace blank with zero in the measure calculation.
like if measure is blank then 0 else measure.
but I want to connect them that the data point goes directly to the other and not to 0 in between
but this would be inaccurate, this would mean that there was data on this level and there wasn't, isn't this misleading ?
it would not, it would just connect the data points with each other
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.