Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
rachelbi
Helper I
Helper I

Add public holiday into MAQ calendar

Hi, may I ask if someone get to know how to add the public holidays into the MAQ calendar ? I tried to get the table source from Public holidays | Recreation, sport and arts | Queensland Government (www.qld.gov.au) then I don't know how to link with the calendar visual. Thank you very much.

 

rachelbi_0-1713768856865.png

 

1 ACCEPTED SOLUTION
ShobhitGupta
New Member

Hi,

To display holidays in your calendar visual using a JSON format, follow these steps:

1. Locate the "Holidays" section within the "Format visual" panel.
2. Copy the provided sample JSON code (also mentioned as placeholder):

{
    "holidays": [
        {
            "startDate": "January 1, 2024",
            "endDate": "January 1, 2024",
            "title": "New Year's Day"
        }
    ]
}
3. Replace the sample dates and names with your desired holidays in the format given.
5. Paste the edited JSON code into the "Holidays" section.
6. Click "Apply" to update your calendar visual with the specified holidays.

I Hope this answers your query.

Regards,

Shobhit from MAQ Software

View solution in original post

5 REPLIES 5
Manjarigoyal1
Frequent Visitor

@ShobhitGupta @amitchandak I have a company's holiday dates how can I add it to the MAQ calendar. I tried the json code which you have provided above but I can't add multiple dates. I need to add all these holiday dates 

Manjarigoyal1_0-1720802101009.png

 

I got my answer. they don't have the functionality to do so. I need to add all the holidays in my event table. If anyone else have better solution please let me know

Public Holiday – MAQ Software (zendesk.com)

ShobhitGupta
New Member

Hi,

To display holidays in your calendar visual using a JSON format, follow these steps:

1. Locate the "Holidays" section within the "Format visual" panel.
2. Copy the provided sample JSON code (also mentioned as placeholder):

{
    "holidays": [
        {
            "startDate": "January 1, 2024",
            "endDate": "January 1, 2024",
            "title": "New Year's Day"
        }
    ]
}
3. Replace the sample dates and names with your desired holidays in the format given.
5. Paste the edited JSON code into the "Holidays" section.
6. Click "Apply" to update your calendar visual with the specified holidays.

I Hope this answers your query.

Regards,

Shobhit from MAQ Software

But when I put a new holiday in the same month, the visual just delete the other holiday. How to put more the one holiday in the same month?

 

amitchandak
Super User
Super User

@MAQSupport , please help

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.