Forum Discussion
Problem with Selection in custom visualization
Thanks for your suggestion.
How can I create calendar table in hours as i have created calendar table for date purpose but how can i put time in it and bifurcate it to hours. It will be very helpful if you can show the DAX for it.
You can try
calendar table in hours =
SELECTCOLUMNS (
ADDCOLUMNS (
CROSSJOIN (
CALENDAR ( "2016-01-01", "2017-12-31" ),
SELECTCOLUMNS (
ADDCOLUMNS ( CALENDAR ( "2016-01-01", "2016-01-24" ), "DAY", DAY ( [Date] ) ),
"DAY", [DAY]
)
),
"dateTime", [Date]
+ IF ( [DAY] = 24, 0, [DAY] )
/ 24
),
"Date", [Date],
"dateTime", [dateTime]
)
thanks.
But, my requirement is to have a time slicer that can slice my data from one time to other time . and power BI dosen't have such time slicer.
Do you want to slice a time window like '02:00' to '15:00' for all days? If so, there's some workaround by creating proper lookup tables and measures.
Check a similar thread Specify custom date periods with predefined date periods. The difference is, you have to create start time and end time and filter the data with them, rather than start date and end date in that link.
Thanks for this help. But can you please tell me how can i make a table with range of time only not date.
Because Calendar() function is taking date only.