Calendar Visual Disappearing

[pierre415]

Hey guys,

I'm looking to make a calendar that shows the leaves per day in a company. When I sort leaves by just the Start Date, the visual works well:

But I want it to show All dates of each leave, not just the start date. I have this column but when I use All Dates instead of Start Date the visual disappears. Here's the data I'm using

where lines with the same index are the same leave, more lines meaning a longer leave. At first I thought 'All Dates' wasn't displaying because there were too many dates, or because of some data formatting issue, but it looks like it's something else. Any ideas guys?

Thanks!

Pierre 

[v-huizhn-msft]

Hi @pierre415,

You select the 'All Dates' as category, the 'count of index' as value, the visual disappers? As I tested, it works fine. Please check if there other fields affect the 'All Dates' column, or do you mind share your .pbix file for further analysis? I can not reproduce your scenario without your file. Thanks for understanding.

Best Regards,
Angelia

[pierre415]

I also found that for some reason if I filter my All Dates column in any way the calendar shows up fine. So you could say it actually works but I need a more permanent solution... 

[v-huizhn-msft]

Hi @pierre415,

I can not reproduce your scenario, you just replace the StartDate to AllDates, it disappers? Please create a new visual, select the AllDates as category and 'count of index' as value level.

Best Regards,
Angelia

[pierre415]

Hi, could you give me an example of another field affecting 'All Dates'? I could send you the file as soon as I get permission from my boss. Thanks,

Pierre