Forum Discussion

IF's avatar
IF
Post Prodigy
5 years ago
Solved

Start and end selection with datetime

Hi,

 

I want to show values in a graph based on the DateTime selection (highlighted in red).  If I use a slicer it shows only the days not the hours as well (highlighted in orange).

I checked:

https://community.powerbi.com/t5/Desktop/datetime-slicer/m-p/604728#M287867

Maybe this is not possible but would like to learn at least.

 

Thanks in advance!

Need Help

4 Replies

  • Portrek's avatar
    Portrek
    Resolver III
    5 years ago

    Hi.

     

    You need to change the format, look the image below.

     

     

    Select the column date and choose the format that you want.

     

    Best regards.

  • Portrek's avatar
    Portrek
    Resolver III
    5 years ago

    Hi IF.

     

    Choose the option like shows in the image below.

     

     

    See you o/

    • IF's avatar
      IF
      Post Prodigy
      5 years ago

      Hi, I tried that one but shows only with date format and doesn't include the hours. Thanks for the reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi IF 

     

    Currently when you use the date range slicer (Between, Before, After), it will only show the dates in the Short Date format which is consistent with the short date format settings on your browser or operating system locale, which is by design. See document: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-slicer-numeric-range#display-formatting-with-the-date-range-slicer

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.