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.

     

     

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.