Forum Discussion

NAMI1356's avatar
NAMI1356
Advocate 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
    Microsoft 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