Linechart with Blanks

Question

Hi all,&nbsp;I have to create a cobmochart (linechart &amp; 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???&nbsp;Thank you in advance.&nbsp;

nandukrishnavs · Answer

Anonymous&nbsp;&nbsp;Could you share your pbix file/ sample dataset and measure logic?&nbsp;

amitchandak · Answer

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 · Answer

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.&nbsp;Thanks a lot in advance

anonymous · Answer

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.&nbsp;Thanks a lot in advance.

v-xicai · Answer

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

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

&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
Best Regards,
Amy&nbsp;
&nbsp;
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.

Forum Discussion

Linechart with Blanks

6 Replies

Related content

Tooltip on linecharts

Tooltip in LineChart

Blank Page - Embedded Report

Forecast Model In Linechart

Counting Non-Blank Records