Forum Discussion

mkz81's avatar
mkz81
Frequent Visitor
1 year ago
Solved

How to build line chart date and time based?

Hi! I'm trying to build a line chart where X-axis would be date and time binded. Although I've built date and time tables my chart doesn't represent data sequentially i.e. date and time based. Instea...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Having separate Date and Time columns is very good practice for exactly the reason I mention (the blue "i"). But if you want a continuous X axis (as you seem to imply) then the continuous value column is your only good option.

     

    Try not to fall into the trap of attempting to dictate to your report users how they should navigate your report UI. Embrace the Power BI way of doing things.

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

mkz81 

Combine Date and Time into a Single Column

DateTimeCombined = 'Table'[Date] + 'Table'[Time]

Go to the "Format" pane for the line chart.
Under "X-axis," set the type to Continuous.

 

Make sure DateTimeCombined is added to the X-axis.
Ensure that the Values field of the chart uses the correct aggregation (e.g., Sum, Average, etc.).

 

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn