Forum Discussion
Date and Time slicer from Calendar table
Hi,
Thank you for your response. I am still not able to filter using start and end time tables as you have mentioned. When I select the End time the data table vanishes. Please find an example as below. Can you please advise how do I get the data filtered for time.
https://www.dropbox.com/s/h7ue7lcyaz487t9/Test_Table.pbix?dl=0
Resolver IIn this .pbix example (OneDrive shared file), I used data from timeanddate.com that shows daily sunrise and sunset times in Seattle and Anchorage (so there's more than one time period per day) for Feb - Apr.
There are four tables that will contain the values in each slicer. The slicers are for StartDate, StartTime, EndDate and EndTime (StartTime represents sunrise time and EndTime represents sunset time...you can adjust these to the appropriate beginning/end of selected time period in your dataset). Do not create relationships between any of these tables and the fact table.
Then add the measure below to the visual level filter and set it to is not blank (in this example the visual is the table). Hope this helps.