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.
I'm creating a heatmap that looks like:
Each cell represents the sales of a restaurant on a given day, at a given hour. The issue I have is restaurants often operate past midnight, and it's still considered the same "work day". So the first two rows actually represent the sales from the previous day.
Does anyone have any ideas how to adjust the time signature to make each column go from 2 PM to 2 AM?
Solved! Go to Solution.
You can do similar to Fiscal Calendar implementation. You need to build a table that covers all days and hours of restaurant.
Calendar Day | Calendar Time | Restaurant Day | Restaurant Time | Index
FRI | 2PM | FRI | 2 PM | 2
...
FRI | 10PM | FRI | 10 PM | 10
FRI | 11PM | FRI | 11 PM | 11
SAT | 12AM | FRI | 12 AM | 90
SAT | 1AM | FRI | 1 AM | 91
SAT | 2AM | FRI | 2 AM | 92
and for the Restaurant time, set the sort by columns as "Index"
and hide the index column from reporting "hide in report view"
and use the Restaurant Day, Restaurant time for your reporting.
Hope this helps~!
You can do similar to Fiscal Calendar implementation. You need to build a table that covers all days and hours of restaurant.
Calendar Day | Calendar Time | Restaurant Day | Restaurant Time | Index
FRI | 2PM | FRI | 2 PM | 2
...
FRI | 10PM | FRI | 10 PM | 10
FRI | 11PM | FRI | 11 PM | 11
SAT | 12AM | FRI | 12 AM | 90
SAT | 1AM | FRI | 1 AM | 91
SAT | 2AM | FRI | 2 AM | 92
and for the Restaurant time, set the sort by columns as "Index"
and hide the index column from reporting "hide in report view"
and use the Restaurant Day, Restaurant time for your reporting.
Hope this helps~!
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 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |