Forum Discussion
PowerBi Desktop Calendar One to Many
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
Hi Anonymous
all you need is to activate parameter Show items with no data for Date field in your visual
