Forum Discussion
Solved
Can i blink background on data refresh?
I have a dashboard report for our company which one updates every 30 min. I wanted to do when one value increased or decreased blink. can i do that?
I cant do blink but i changed background which data updated.
First i created measure like this: SUM(App[CarBought?])
After i created second mesure like this:
Before Last 30 Count=CALCULATE(SUM(APP[CarBought?]),DATEDIFF(App[LastModifiedOn],NOW(),MINUTE)>30,App[Status]=800)i substracted these measure values and handled with if statement like this:
BlinkTrue=IF(SUM(App[CarBought?])-[Before Last 30 Count]>0,1,0)And finally i created conditional formatting background. like this:after that when data refreshed, if instant data count different with before 30 min count it changes background
after your response i just created a mesure which one count data before 30 min. and created another mesure which one substract this measure value with current value. with if statement if these two value bigger than 0 1, else 0. and i did conditional formatting for background. if this value 1 background is black. Waiting for new data now. I hope it works