Power BI line chart over Date/Time on Axis

Question

I need to create a line chart with time line on Axis and display the Date hierarchy ( day, month, quarter, year ) each in separate line below the axis representation. All the telemetry data is in continuous 10 min span range on the same calendar day and hour. I've two separate fields representing the time only and date. I tried drill down option but not able to achieve that. could you please help me in this regard?

Answer 1

Excel 365 Pro Plus with PowerPivot and Power Query (aka Get & Transform)
Plot by year/quarter/month/date/hour/minute.
Bridges 4 hr period over NewYear.
http://www.mediafire.com/file/cb7nxh2ar4kbjtz/07_09_19b.xlsx/file
http://www.mediafire.com/file/1drc45rz8jr1ivo/07_09_19b.pdf/file

Answer 2

Thank you for the info. That's exactly what I would like create - a  line chart in PowerBI desktop but unfortunately I am not able to get it right.
 Sorry for posting this question under power pivot thread as my question is related to PowerBI desktop.

Answer 3

RaysApps, did this not help? Do you have a specific question? 

Thanks!

---

Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!