Forum Discussion

admfabiomachado's avatar
6 years ago
Solved

Datetime filter on dashboard

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 fi...
  • GilbertQ's avatar
    6 years ago
    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's avatar
    6 years ago

    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.