Forum Discussion

JRP515's avatar
JRP515
Frequent Visitor
6 years ago
Solved

How To Get Data Slicer to Automatically Update when Refreshing Data

Im working on a dashboard with multiple tabs and various data sources.   I don't know how I did it, but in one of the tabs, when you refresh the data, the date slicer automatically updates the seco...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi JRP515 

    If the date table is dynamic, the "between" date slicer can be dynamically updated to most recent date.

    Here is a example, if i create a date table as below,

    Next day, the slicer would move to 2019/9/25

     

    In you date table, are there dates until most recent date or until the current year end?

    Please show more detials so that i can help you better.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi JRP515 

If the date table is dynamic, the "between" date slicer can be dynamically updated to most recent date.

Here is a example, if i create a date table as below,

Next day, the slicer would move to 2019/9/25

 

In you date table, are there dates until most recent date or until the current year end?

Please show more detials so that i can help you better.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JRP515's avatar
JRP515
Frequent Visitor
6 years ago

Thinking about it further - this is the best way to go about it. We have date tables for most of our dashboards, and setting the second date TODAY() is what we need! It will take a few additional steps and workarounds, but definitely the best option.

 

Thanks!