Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |