Issues with Holiday JSON and Default Date in Calendar Visual by MAQ Software

[Rfranko23]

Hi,

I am using the Calendar Visual by MAQ Software in my Power BI report and am experiencing two issues:

1. **Holidays JSON Limitation**: The visual does not seem to support multiple holiday entries in the JSON. When I add more than one holiday, only the first entry is applied; the rest are ignored. This limitation makes it challenging to highlight multiple holidays throughout the year, which would be very helpful and seems to be intended based on the JSON structure.

2. **Default Date Not Showing Current Month**: When I open the report, the visual always displays the last saved view (e.g., December) instead of defaulting to the current month (e.g., April). I expected it to show the current date when the report is opened automatically.

Has anyone else encountered these issues and found a workaround or solution?

@MAQSupport, could you please confirm if these are known limitations and if there are any plans to address or improve them?

Thank you in advance for your help!

[v-kathullac]

Hi @Rfranko23  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @Rfranko23  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @Rfranko23  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac · Accepted solution]

Hi @Rfranko23,

Thank you for reaching out to Microsoft Fabric Community Forum.

can you these below steps to resolve your issue

1) Check the JSON format: Ensure your JSON is a valid array of objects. Here's an example format that should work

sample json:

[
{
"date": "2025-01-01",
"label": "New Year's Day"
},
{
"date": "2025-12-25",
"label": "Christmas"
},
{
"date": "2025-08-15",
"label": "Independence Day"
}
]

Make sure you're using the latest version of the visual from AppSource, as older versions had known bugs with holiday JSON parsing.
If the issue persists even with correct formatting, try with just two holidays and test incrementally.

2) dynamic calculated column:
IsCurrentMonth =
IF(
MONTH(Calendar[Date]) = MONTH(TODAY()) &&
YEAR(Calendar[Date]) = YEAR(TODAY()),
1,
0
)
Then filter the visual or page to display where IsCurrentMonth = 1

Regards,

Chaithanya.