Forum Discussion

BPOPE's avatar
BPOPE
Frequent Visitor
8 years ago

Help needed!! Data modeling: Time

Hi   I'm relatively new to BI so still getting to grips with it.  I'm having an issue with time when importing from excel.  My data is the length of time someone has spent on a call.  In excel its ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi BPOPE,

 

I have made a test but can't reproduce your issue. My steps are like belw:

 

Create a sample in excel -> Load table to power bi -> Change format of data type.

  --->      --->     --->   

 

If this issue still exists, could you please provide some dummy data for further analysis?

 

Regards,

Jimmy Tao  

  • BPOPE's avatar
    BPOPE
    Frequent Visitor
    8 years ago

    Thanks Jimmy, I did a bit of reformating in Excel and BI is now allowing me to change the data type to Time which is great.  The issue I have now though is no auto sum is appearing on the Time Data so it's only giving me the option for Counts when trying to use it for visuals.  Any ideas on why it would do this?

     

    thanks

     

    Ben

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      8 years ago

      Hi BPOPE,

       

      The text type or data time type of value can't be sumed, can only be counted, you should sum values like number type value.

       

      Regards,

      Jimmy Tao