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
what were you expecting to see? there are plenty of calendar type custom visualisations https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=calendar&page=1
which may or may not work for you. It just depends on what your expectation is. You need to give a clearer idea of what how you are wanting to display this information.
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/