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. 

 

I check other charts and there is the same problem if the chart doesn't have change format option inside (e.g. Power KPI 2.0.0 has this option, but it allows to show data from only one day and I need to show the data from longer period).

 

The data source of this visualisation is the the Power BI Data Source and there is the 24-hours format set for this column.

I use live connect mode and in this case I can't change the format in column settings and I don't have access to Power Query Editor. 

 

I want to have the same format on the axis and inside the chart (12-hours with AM/PM or 24-hours, but the same everywhere). 

 

Thank You for all ideas,

Ewelina

 

 

 

 

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.

     

     

6 Replies

  • DataZoe's avatar
    DataZoe
    Microsoft 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
        Microsoft 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.