Can i blink background on data refresh?

[sercaneryaz]

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?

[sercaneryaz · Accepted solution]

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

[sercaneryaz]

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

[sercaneryaz]

no i got only this measure. im connecting with direct query

[Greg_Deckler]

@sercaneryaz I don't see how that is possible if you don't have anything to compare it to. You can get blinking if you use SVG such as this: SVG Animation - Bouncing/Blinking Stephen Few 'Red... - Microsoft Power BI Community

[sercaneryaz]

no i dont have. i just have this value with direct querry

[sercaneryaz]

yes Measure is Car Bougth =CALCULATE(COUNT(App[Guid]),App[Status]=800)

[amitchandak]

@sercaneryaz , do you have a measure that can tell difference between the value before and after refresh