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.

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

Yeah, tough.  You'll need to make compromises. 

 

Use a DateTime column for the continuous X axis and let the visual handle the axis legend.  Use Zoom Sliders for a better UX.

 

NOTE:  Blue "i"  - too many data points.

 

 

mkz81's avatar
mkz81
Frequent Visitor
1 year ago

Hi Ibendlin! Thank you for the proposal! I actually split the time/date column hoping to use my Date and Time tables. Is there a way of doing it instead of using concatenated column?