Forum Discussion

Ewelina's avatar
Ewelina
Frequent Visitor
5 years ago
Solved

Different time format on area chart axis and tooltip

Hello,   I have a problem with time format on area chart. On the x-axis, it is 24-hours time format, but when I put the cursor on the line, the tooltip shows 12-hours time format wihout AM/PM.  ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Ewelina 

    What is kind of visualization  you are using?

    Affected by the format of the original date field (the format  the date field in the PowerBI dataset), the tooltip will still display the same format (the 12-hour time format without AM/PM).

    Workarounds1：

    Republish a new dataset to PowerBI service after changing the date format on powerBI Desktop.

     

    Workarounds 2:

    Create your own custom  tooltip (new measure using function 'format' ) 

     

    Measure1 = format(SELECTEDVALUE('Table'[Date]),"yyyy-mm-dd hh:nn:ss")
    Measure 2 = format(SELECTEDVALUE('Table'[Date]),"mm/dd/yyyy hh:nn:ss AMPM")

     

     

    default tooltip:

     

    custom tooltip :

     

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

DataZoe's avatar
DataZoe
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Hi Ewelina, even in a direct query model, you should be able to click on the datetime on the right side of the screen (in the Fields pane). Then you should be able to pick a format that works for you.

Ewelina's avatar
Ewelina
Frequent Visitor
5 years ago

Hi DataZoe,

 

I tried to change format this way, but it isn't possible.

 

 

  • DataZoe's avatar
    DataZoe
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    Ewelina If I am understanding correctly, it looks like it is a text datatype which is why it's not allowing you to change it. If it were a date datatype then it would be ok to change it. 

     

    Another idea is to utilize it as a composite model. In this way you would create a new date table in DAX and then join it to your direct query table. In the new table you can format it however you please. 

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Ewelina 

    I didn't find anything wrong on my side.

    Please make sure you have changed the connection mode from  live connect mode to directquery mode before  you change the format .

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Ewelina's avatar
      Ewelina
      Frequent Visitor
      5 years ago

      Hi v-easonf-msft,

      it's my mistake, I use live connect mode, not directquery mode. 
      I don't understand why the time format on x-axis is different than the one the tooltip shows.
      Have You any ideas why is that and how to change it using live connection?

      Best Regards,

      Ewelina

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi, Ewelina 

        What is kind of visualization  you are using?

        Affected by the format of the original date field (the format  the date field in the PowerBI dataset), the tooltip will still display the same format (the 12-hour time format without AM/PM).

        Workarounds1：

        Republish a new dataset to PowerBI service after changing the date format on powerBI Desktop.

         

        Workarounds 2:

        Create your own custom  tooltip (new measure using function 'format' ) 

         

        Measure1 = format(SELECTEDVALUE('Table'[Date]),"yyyy-mm-dd hh:nn:ss")
        Measure 2 = format(SELECTEDVALUE('Table'[Date]),"mm/dd/yyyy hh:nn:ss AMPM")

         

         

        default tooltip:

         

        custom tooltip :

         

         

        Best Regards,
        Community Support Team _ Eason
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.