Visual Calendar

[Syndicate_Admin]

Good afternoon!

I'm creating a calendar visualization to show the dates employees go on vacation, then I show the picture.

I need to remove Saturdays and Sundays from the visualization and create a color marking for the holidays, can you help me?, I have already tried different strategies but I do not achieve my goal, thank you! , then show the fields used in the visualization.

[Anonymous · Accepted solution]

Hi @Syndicate_Admin 

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:

Power BI Calendar Visual

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.

[Syndicate_Admin]

Thanks for the reply.

[Anonymous]

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

[MFelix]

Hi @nataliaguzman02 ,

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.