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
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