Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Time range in Power bi

Good! I have a problem when adding a range of hours since PBI detects some dates and they are not the one I have in the database, some way to make a range of hours?

  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi Syndicate_Admin  

    Thanks for reaching out to us.

    you can try this,

    (1) create a calendar table and put date column into slicer

     

    calendar = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))

     

    (2) create a date table based on your original table

    Date = VALUES('Table'[Date])

     

     

    Best Regards,

    Community Support Team _Tang

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

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Syndicate_Admin  

    Thanks for reaching out to us.

    you can try this,

    (1) create a calendar table and put date column into slicer

     

    calendar = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))

     

    (2) create a date table based on your original table

    Date = VALUES('Table'[Date])

     

     

    Best Regards,

    Community Support Team _Tang

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