Calendar Visual positions appropriate to underlying dataset

[GaryLaurelIT]

I have produced a report for a client who requires a screen showing upcoming production in his workshop.

The report uses Calendar Visual by MAQ software to show the days of the current week, under which is a list of tiles/jobs that needs doing.  A Relative Date filter is set to only include data for the current week.

The screen automatically refreshes periodically and at the start of each week, uses the Today button to ensure the current week is displayed.

There is otherwise no user interaction with the report.

The customer has now asked for the same report but showing next weeks data instead.  This is easy to prepare by just changing the relative date to pick up the next week.

However, when the next week report is published, the embedded URL appears to define the week that will be displayed.  Therefore, on Monday morning the view stays in the original week.  If I manually advance the week displayed using the controls the data appears as expected, however, when the report refreshes it reverts to the original again.

The only workaround I have at the moment is to manually amend and republish the report each Sunday to ensure the correct week is displayed on Monday morning.

I can't find any functionality within Powerbi or the visual we've used to provide the behaviour we need (the developers have confirmed their visual does not currently support it).  Has anyone achieved anything similar which they can share please?

I have started looking at TamperMonkey but I can't envisage how it would actually accomplish what I want to do anyway.

[Poojara_D12]

Hi @GaryLaurelIT 

The customer has a report in Power BI using the Calendar Visual by MAQ software, which displays the current week's production schedule in a workshop. The report is set up with a Relative Date filter to show only the current week's data, and it automatically refreshes periodically to ensure the current week is displayed using the "Today" button. However, the customer now wants a similar report for the upcoming week. While it's easy to adjust the filter for the next week, the issue arises when the report is published. The embedded URL seems to lock the displayed week, causing it to revert to the original week on Monday morning after the report refreshes. The only current solution is to manually update and republish the report each Sunday to ensure the correct week is shown. The customer has explored using TamperMonkey but hasn't figured out how it could solve the issue, and there doesn't appear to be any built-in functionality in Power BI or the visual to support the behavior they need.

[v-csrikanth]

Hi @GaryLaurelIT 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @GaryLaurelIT 
In addition response to @Akash_Varuna i can suggest below possible ways that resolves your issue.
Your issue stems from the fact that the Calendar Visual by MAQ Software does not dynamically adjust the displayed week based on relative date filters once the report is embedded. Since the embedded URL stores the week selection, the report does not automatically shift to the next week on Monday morning, even though the underlying dataset updates.
As per my undertsanding below are the workaround that meets your requirement.

If manual republishing is your only workaround, Power Automate can automate this. You can:

• Schedule a flow to refresh the dataset every Sunday night.
• Use Power BI REST API to republish the report with the correct date selection.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.

Best Regards,
Community Support Team _ C Srikanth.

[GaryLaurelIT]

That would be a shame,  the visual is otherwise doing a lot of good work in terms of presenting the data clearly with colour coding etc.

[Akash_Varuna]

Hi @GaryLaurelIT ,You could try by replacing the MAQ Calendar visual with a custom Power BI table or matrix visual. Use calculated columns in Power BI to determine the "current week" and "next week" based on the system date. Then, apply filters dynamically using DAX measures or a relative date slicer, ensuring that the report always shows data for the correct week without manual intervention.