Linechart with Blanks

[Anonymous]

Hi all,

I have to create a cobmochart (linechart & barchart) but unfortunately there are some blanks in my data. As a result my graph has gaps.

Is there any way in Power BI to connect the data points with the line as it happens in excel???

Thank you in advance.

 

[v-xicai]

Hi   @Anonymous ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @Anonymous ,

If your X axis is "Continuous" , simply create a measure with the following formula to turn all blanks into zeros.

Total Amount = IF(ISBLANK(SUM(Table1[Amount])), 0, SUM(Table1[Amount]))

Best Regards,

Amy 

Community Support Team _ Amy

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

[amitchandak]

@Anonymous , Add +0 so it goes to 0. Or refer to couple of suggestion here

https://stackoverflow.com/questions/51402676/power-bi-make-a-line-chart-continuous-when-source-contains-null-values-handle

[Anonymous]

I have already check that link but i don't want to interpolate my data or fill them with 0.

I guess i will leave it as it is.

Thanks a lot in advance.

[Anonymous]

Thanks a lot but i have already check this link on my own. I do not want to interpolate my dataset or fill my data with 0.

I guees i will leave it as it is.

Thanks a lot in advance

[nandukrishnavs]

@Anonymous 

Could you share your pbix file/ sample dataset and measure logic?