Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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...
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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |