Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Robert_G
Frequent Visitor

time base change of filter

Hi, I´m wondering if it is possible to change the filter of an visual automatically, lets say every 2 min. I´m having a report beeing visible for all teammembers on a monitor in our room. My idea is to have something like a "carousel report" where the displayed information changes periodically. It it possible?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Robert_G , You can have a measure that shows data for the last 2 minutes. If you are in the direct query you can set automatic page refresh

 

or use play axis visual https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380981?tab=overview

 

Measure = calculate(Sum(Table[Value]), filter(Table, Table[Date time] >= now() -time(0,2,0) && Table[Date time] <= now() ) )

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Robert_G , You can have a measure that shows data for the last 2 minutes. If you are in the direct query you can set automatic page refresh

 

or use play axis visual https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380981?tab=overview

 

Measure = calculate(Sum(Table[Value]), filter(Table, Table[Date time] >= now() -time(0,2,0) && Table[Date time] <= now() ) )

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.