Line chart, count of occurances within a day. How to display zeros?

[Anonymous]

Hi there.

im creating a line chart with date hierarchy on axis -> year, month, day

on axis y there is count of ID's of events. There are some days without an event. I would like to display them as well. For now i get connected line and it seems like there was 1 event for days where actually there is no data. btw. i have the date table outside of my fact table with everyday of a year

[Anonymous · Accepted solution]

I found solution myself. Created Measure:

COUNT(table[ID]) + 0

so now power bi knows that null is 0 for me.

cheers

[v-kelly-msft]

Hi @Anonymous ,

Glad that you have solved the problem,so can you make the post as answered to close it?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

Refer if this option can help on date

[Anonymous]

unfortunately, no

[amitchandak]

Can you share sample data and sample output.