Forum Discussion
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
7 Replies
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
- amitchandak
Super User
sercaneryaz , do you have a measure that can tell difference between the value before and after refresh
yes Measure is Car Bougth =CALCULATE(COUNT(App[Guid]),App[Status]=800)
no i dont have. i just have this value with direct querry
no i got only this measure. im connecting with direct query
- Greg_Deckler
Community Champion
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
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
