Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Advice requested how to structure data

Hi everyone,   I'm looking for some help/advice/tips on how to structure some data for an analysis I need to do.   Data input (simplified examples): - table1 (power consumption): every mi...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    Currently, for the Date/Time field, it is only support to drill down to the day level but not the time level.

     

    You may refer to the formula in this case : https://community.powerbi.com/t5/Desktop/Time-based-chart/m-p/648917#M311161.

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Currently, for the Date/Time field, it is only support to drill down to the day level but not the time level.

 

You may refer to the formula in this case : https://community.powerbi.com/t5/Desktop/Time-based-chart/m-p/648917#M311161.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.