Forum Discussion
Calendar Visual
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated column.
Column = IF(TODAY()>=[Start Date]&&TODAY()<=[End Date],1,0)2. Create measure.
vailable = var _noavailable=SUM(Merge[Column]) return COUNT(Dataset1[Employee Name])-_noavailable3. Use the card chart to place the measure in
4. Result:
Today is 2021.9.16. According to the conditions, neither of them is in working hours, so no one today
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi,
Thanks for your response. I have tried numerous of these calendar visuals but couldn't achieve the desired look.
Please find an example report visual attached.
Hope this helps.https://www.dropbox.com/scl/fi/xh5axxgbpy65rlnfr3x3c/Labour-Availability-Example.docx?dl=0&rlkey=n9eixh6n0atcqivn0pn0rh6y5
unfortunately if you can't find the correct visual in the custom options then it doesn't exist. You either need to develop your own visual which for most people isn't really realistic or think about adjusting your requirements in how you demonstrate this. There is however this which is charticulator which might be of use to you, i haven't used it but it looks like it might have potential.
https://www.burningsuit.co.uk/blog/2021/06/charticulator-in-power-bi-1/