How to disappear previous data when timezone changes to 12:00 of next day

[Sowmiya]

Hi Community,

My Client requested that the data from sharepoint which is displaying current day data in Power bi desktop should disappear when the timezone changes to 12:00 of next day. Previous day data disappear and dashboard should shows empty data.Until client started to work  next day from 7:00 A.M.  Is this doable in Power Bi

[Greg_Deckler]

Quite probably but need a lot more info and a clearer explanation. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Sowmiya]

Hi @Greg_Deckler

Consider my dashboard visualizing for current day (11-12-2018) and my time zone is UTC+5:30. When my time reaches 12:00:00 A.M. i.e., 11-13-2018. Then my dashboard visualizing previous day i.e., 11-12-2018 wants to be disappear and the dashboard data remains to empty. Until I update the data by next day 11-13-2018 at 07:00:00 a.m. the dashboard visualize only empty data. When I update my first data at 11-13-2018 07:00:00 a.m. the dashboard should gets the data and visualize the data for 07:00:00 a.m.

Regards,

Sowmiya

[Greg_Deckler · Accepted solution]

OK, and does your data have a timestamp in it that denotes what day it is for? If so, you could create a measure that is essentially:

IsToday = 
IF(MAX([Date])>=TODAY(),1,BLANK())

You can then add this to your visuals or filter on IsToday = 1.