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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors