Forum Discussion

NAMI1356's avatar
NAMI1356
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Refresh Dashboard based on Selected Week Filter

Hi ,    We Developed a Dashboard which needs to be Refreshed only Based on Selected Week in Filters.   Scenario:  Sales in our report have  2 staged 1- Booked (Sales are booked but not confirme...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi NAMI1356

     

    If you want to keep track of historical data currently that is not capable in Power BI.

     

    What I would suggest is a better way of doing this, is to ensure that your source system where your data comes from can store historical data? Or find a way to use a Data Warehouse or something similar to store the historical data.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi NAMI1356,

    As the GilbertQ said, when we refresh, the new data will override the old data. Power Bi can not store the history data. There is a idea, you can vote it.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi NAMI1356,

As the GilbertQ said, when we refresh, the new data will override the old data. Power Bi can not store the history data. There is a idea, you can vote it.

Best Regards,
Angelia