Forum Discussion

Pimmoz's avatar
Pimmoz
New Member
9 years ago

How to show date / time in final chart?

Hi all,   Anyone know how I can show the decimal value back to time (HH:MM) like in this time plot chart? Many thanks in advance.   Tbh, I really find it strange for Power BI and Excel (Pow...
Need Help
Tips and Tricks
BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Go to the Modelling Tab, Select the Foratting option, Select the correct data type (Time) and format as HH:MM.

Pimmoz's avatar
Pimmoz
New Member
9 years ago

Thanks for your aswer,

 

I've thought that would be the answer but as show in the below image these option are grayed out.

 

Perhaps it has something to do with the query formating options?

 

Many thanks in advance.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Pimmoz,

     

    In your scenario, the data type of column [Max of duration] is decimal, it can be displayed well in a chart according to the length of bars. However, if you force to change its format to HH:MM, the data type will be changed to text. The chart cannot display as before because Y-axis only supports numerical value, if adding text value on Y-axis, it will be aggregated by default.

     

    Thanks,
    Yuliana Gu