Forum Discussion
Helper ICalendar Visual Disappearing
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
4 Replies
v-huizhn-msftMicrosoft Employee
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
pierre415Hi, 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
- 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