PowerBi Desktop Calendar One to Many

[Anonymous]

Hello,

I am having trouble visualizing and coding my calendar to show what I need.

I am trying to link a calendar table with a date field from my other data source. The other data source has mutliple documents associated with one given date, so it's a one-to-many relationship.

I want to be able to have the calendar show up as the primary column, then have the number of documents associated with that day to populate. I want to show the blanks in the table.

For example, I want to show this:

Date	Document #'s
6/1/2019
6/2/2019
6/3/2019
6/4/2019
6/5/2019
6/6/2019
6/7/2019	1
6/8/2019
6/9/2019
…
8/16/2019	2

However, the data only seems to populate for when there are document numbers to be counted, like below:

Date	Document #'s
6/7/2019	1
8/16/2019	2

Here is a subset of data that I am trying to work with:

https://drive.google.com/file/d/10eLIADT9xplk2lBRsn3KBNhQ0WqUWleZ/view?usp=sharing 

Thank you,

Rob

[az38 · Accepted solution]

Hi @Anonymous 

all you need is to activate parameter Show items with no data for Date field in your visual

[Anonymous]

Where specifically do I activate that parameter?

-Rob

[az38]

@Anonymous