cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

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

I found solution myself. Created Measure:

COUNT(table[ID]) + 0

so now power bi knows that null is 0 for me.
cheers
5 REPLIES 5
Super User IV

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

Refer if this option can help on date

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin

Frequent Visitor

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

unfortunately, no

Super User IV

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

Can you share sample data and sample output.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin

Frequent Visitor

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

I found solution myself. Created Measure:

COUNT(table[ID]) + 0

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

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

Hi @Wolski ,

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!

## Helpful resources

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors