Microsoft Dynamics 365 | Integration, Dataverse...

Interactive Experience Dashboards - How to set custom time frame

(1) Share

Report

Posted on by Mark1314

Hi All,

I'm hoping someone can help with this as I'm stumped.

I've built an interactive dashboard and current have the time Frame set for this quarter. I'd actually like to have a specific custom time frame as default (for example start as 1/1/2017 end today

Has anyone got a way of doing this?

Many Thanks In Advance

Mark

I have the same question (0)

All responses (6)

Answers (0)

Niktia Polyakov Mic... on at

Like (1)

Report

That does sound useful!

This is not possible currently.

Please create and vote this idea.

Was this reply helpful? Yes No
Suggested answer

Linn Zaw Win 3,407 on at

Like (1)

Report

I am sorry but currently, there is no way to set the default time frame filter value to Custom Time Frame.

The only workaround solution would be

- create a custom date field

- create a scheduled flow which runs overnight to populate the custom date field

- set the default Time Frame as Last quarter

- design flow to update the custom field of the records earlier than last quarter (e.g. records between 1/1/2017 - 31/12/2019) to the date within the last quarter (e.g. 1/1/2020)

Was this reply helpful? Yes No
Arrealius 20 on at

Like (1)

Report

Thank you Linn I'll give that a try as it makes sense as a work around.

Regards

Mark

Was this reply helpful? Yes No
Linn Zaw Win 3,407 on at

Like (0)

Report

Give it a try and let me know if you have any future question.
If the workaround solution can fulfil your requirement, please mark the suggested answer as verified so that it will be helpful for the other community members who have the same requirement.

Was this reply helpful? Yes No
Benoit Delvaux 870 on at

Like (0)

Report

Hello,

This is unfortunately not possible to remove or customize further the timeframe filters.

Please upvote this feature request so maybe it will become possible on day without nasty workarounds:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Disable-timeframe-filter-requirement-for-Interactive-Dashboards/idi-p/395905

Best,

Was this reply helpful? Yes No
CU09011129-0 3 on at

Like (0)

Report

Linn Zaw Win's suggestion is very good.

If you want the Dashboard just to show EVERYTHING by default you can:
- create the custom date only field as a CALCULATED COLUMN

- for the calculation, in the Action set it to NOW()

This will essentially make that custom date field equal the Today's date for every row in the table

- in the Dashboard set the global date filter to that new date column and default it to Today

1 people found this reply helpful.

Was this reply helpful? Yes No