Forum Discussion
Visual Calendar
I have a test in my side. I find that calendar visual doesn't support you to remove Saturday/Sumday. They will show grey out instead of being removed if you remove them in filter. And calendar visual doesn't support conditional formatting.
I think you can refer to this offical blog to add conditonal formatting in custom visual.
Here I suggest you to create a calendar table by Matrix visual.
Create a color measure and use condtional formatting to format the background color.
color measure = IF(MAX('Date'[Date]) in VALUES('List of Holidays in Spain in 2021'[Date]),"Yellow","White")Result looks like as below.
For reference:
Use conditional formatting in tables
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have a test in my side. I find that calendar visual doesn't support you to remove Saturday/Sumday. They will show grey out instead of being removed if you remove them in filter. And calendar visual doesn't support conditional formatting.
I think you can refer to this offical blog to add conditonal formatting in custom visual.
Here I suggest you to create a calendar table by Matrix visual.
Create a color measure and use condtional formatting to format the background color.
color measure = IF(MAX('Date'[Date]) in VALUES('List of Holidays in Spain in 2021'[Date]),"Yellow","White")
Result looks like as below.
For reference:
Use conditional formatting in tables
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply.
Hi Syndicate_Admin ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file without sensitive data.
Best Regards,Rico Zhou