Forum Discussion

MirandaJ's avatar
MirandaJ
Regular Visitor
2 years ago
Solved

Chart update

Hi,

 

I need to create 2 charts on my report that show our task progression: first chart will show progression/status how it is on a Monday and second chart will show progression/status how it is on Friday to compare how the week started and how it ended.

 

However "Monday's chart" shouldn't update when I hit refresh on Friday and viceversa, in order to check comparison on progression/status.

 

The information is not dependant on an specific cell with a date but when I refresh the report.

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MirandaJ,

    Current power bi does not include historical data features, you may need to store these daily records into a temporary database annd add a custom field to remark the operate datetime.

    Then you can getting data from temporary database and use the operate datetime field to filter and analysis records.

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi MirandaJ,

    Current power bi does not include historical data features, you may need to store these daily records into a temporary database annd add a custom field to remark the operate datetime.

    Then you can getting data from temporary database and use the operate datetime field to filter and analysis records.

    Regards,

    Xiaoxin Sheng