cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sercaneryaz
Regular Visitor

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?

1 ACCEPTED SOLUTION
sercaneryaz
Regular Visitor

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:
sercaneryaz_0-1631889293687.png

 

after that when data refreshed, if instant data count different with before 30 min count it changes background

View solution in original post

7 REPLIES 7
sercaneryaz
Regular Visitor

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:
sercaneryaz_0-1631889293687.png

 

after that when data refreshed, if instant data count different with before 30 min count it changes background

View solution in original post

sercaneryaz
Regular Visitor

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

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

@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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

sercaneryaz
Regular Visitor

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

sercaneryaz
Regular Visitor

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

amitchandak
Super User
Super User

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.