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
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 !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!