create dashboard, which show the last refresh date of all reports.

[Sharmi_28]

I want to create dashboard, which show the last refresh date of all reports.
If the report last refresh date is today's date then the background color will be green else the backgroud color will be red.
Please advice. Thanks

[v-yiruan-msft]

Hi @Sharmi_28 ,

If I understand correctly, you would like to display the dynamic background color of report. When the last refersh data is equal to today's date, then the background color is green. Otherwise, red. Base on my research, we can't change the report background color dynamically base on different conditions.

Anyway, there is one workaround. You can follow the steps below to achieve the similar requirement.

1. Create a report template: you can refer the following official documentation to get it

Create and use report templates in Power BI Desktop

2. Base on the previous report template to create the reports

   1) Add the last refresh date: You can refer this link to get it  2) Create a card visual and fulfill the page and put the field [Last Refresh Date] onto the card visual

  3) Create a measure as below

Measure = 
IF (
    DATEVALUE ( MAX ( 'Last Refreshed Date'[Last Refresh Date] ) ) = TODAY (),
    "green",
    "red"
)​

  4) Set the background color of visual as below screenshot  5) Duplicate this page to multiple pages which you will want to create, then create any visual in these pages

Best Regards

[Sharmi_28]

Hello, 
Appretiate for your reply. 
I have created one dashboard and have multiple reports.
In dashboard I want to pinned last refresh date of all other reports. 
In that reports I displayed last refresh date on every reports in card visual and wrote measure which return color base on today's date condition. It is working correct in report level but when I pinned that card in dashboard the colour which return from measure will not reflect on dashboard.
I hope you understad what I trying to say. 
For example 

[v-yiruan-msft · Accepted solution]

Hi @Sharmi_28 ,

I'm afraid that it can't be achieved by pining a card visual to dashboard with dynamic background color. There are some following limitations when pin the visual to the dashboard, it include that the background settings are ignored in the pinned tile... It means that the background color of card visual will not be display when pin it to the dashboard.

You can consider Pin an entire report page , but the precondition is that you can include all of these card visuals from different reports into one report... 

Datasets - Get Refresh History In Group

Best Regards

[Sharmi_28]

Thank you. "You can consider pin an entire report page" worked for me