Datetime filter on dashboard

[admfabiomachado]

Hello, is there any possibility to include a filter button with date and time? I was only able to include this button with a date, without the possibility of defining the start and end time of the filter. The field is datetime.

[GilbertQ · Accepted solution]

Hi there

Currently you would need to have another button which would be relative time?

The relative time is a new feature in the May version of Power BI Desktop.

[v-xicai · Accepted solution]

Hi @admfabiomachado ,

It is not supported to display DateTime in Between, After, Before, Relative Date option of slicer visual in Power BI currently . There is an idea about this issue, please vote it up,  Datetime slicer, and you can add your comments there to improve Power BI and make this feature coming sooner.

As workaround, you may create two TimeTable  for Hour and Minute like DAX below, see more details: Date and Time slicer from Calendar table.  

startTimeTable = GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 59, 0 ), TIME ( 0, 1, 0 ) )

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ · Accepted solution]

Hi there

Currently you would need to have another button which would be relative time?

The relative time is a new feature in the May version of Power BI Desktop.