Forum Discussion
Display time since last refresh
Hi I have a table in my dataset that contains a calculated field that is last refresh date and time. This will be calculated every time the data is refreshed. I display this on my report. Now ...
Hi ShellyPC ,
Unlike VBA, Power BI doesn't have event triggers that updates a particular measure, say, when you open it. The only scenarios AFAIK when a measure updates it are when:
- a user crossfilters (via visual elements) or fitlers (via slicers) but the moment you go back to the previous state the measure goes back to the previous state as well so that will only add confusion to the users
- a user hits the refresh visuals icon on the upper right of the report in Power BI Service.
Thanks for the input. I think you are probably correct. Before I mark your answer as the solution there is one more piece I want to investigate.
Using the Deneb visual with Vega, it is possible to put a ticking clock on the report. I do not know however if it is possible to take the time from the clock and somehow use that to put up a message or change a color.
I have never looked at Deneb before and until today, had never heard of Vega, so this will take some time. I will come back here and post my findings.
