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 confirmed if going to ship or customer may cancel them)

2- Shipped (Here the Sales are conformed and Shipped) / OR Cancelled (Order Cancelled)

 

We want to Report as below - example

Week 1 Booked: $1000 , Shipped $0   ,  Cancelled: $0

Week2: Booked $5000 , Shipped $500 , Cancelled $100

Week3: Booked $10,000  , Shipped $3000 , Cancelled $500

 

so  when we refresh the Dashbard in Week 3 ,  it shouldnt change the numbers for Week 1 -   it means if we select the Week 1 again , orders in Book 1 (Booked which might be cancelled now in week 3  or shipped in Week 3) and still showing same numbers . 

Week 1 Booked: $1000 , Shipped $0   ,  Cancelled: $0

 

 

or  is there any way we lock our weekly dashboards and save it as seperate pbix file 

 

any other way to keep track of historical data ?

 

Regards,

Nami

 

  • 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.

  • 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

2 Replies

  • 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
    Icon for Microsoft Employee rankMicrosoft Employee

    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