Date/Time drilldown

Question

Hello community,&nbsp;I have a problem with building a dashboard for test data, which lies in the drilldown of the date time format.At the moment&nbsp;I have a column called "timestamp" in the database&nbsp;where&nbsp;i have the date and time data available.But in a normal line chart I can only drilldown&nbsp;a date/time field from Year &gt;&gt;&nbsp;Quarter &gt;&gt; Month &gt;&gt; Day, not to the time, which is what I need, because otherwise I only get a line chart showing the average value of the days...What I need is a line chart e.g. for one month which shows all the data with their actual date and time.&nbsp;Of course I can add two fields to the axis, one for date and one for time, but by drilling down to time then I lose the reference to the date... For example if I filter for one month&nbsp;I get a line chart from 6am to 2pm, where the date of a whole month is shown like it's been in one day...&nbsp;Can this problem be solved? Thank you in advance!&nbsp;

v-piga-msft · Answer

Hi&nbsp;Flo,&nbsp;If I understand your reqirement correctly that you want show the value with their actual date and time.&nbsp;If it is, you could add two fields to the axis, one for date and one for time.&nbsp;1.To enable drill down, select the arrow icon in the upper-right corner of the visualization. When the icon is dark, drill is enabled.&nbsp;&nbsp;2.To drill down&nbsp;one field at a time, select one of the elements in your visualization.&nbsp;&nbsp;&nbsp;&nbsp;Reference: Drill Down&nbsp;If you need additional help please share some data sample and expected output.&nbsp;Best Regards,Cherry

flo · Answer

Hi v-piga-msft,&nbsp;thank you for your answer!I think my problem is a bit different:&nbsp;I already tried to use two different fields, one for date and one for time. The problem is, if i want to drilldown from e.g. year to time,I can only drilldown to day, after that&nbsp;I lose the reference to the date and&nbsp;only get a time axis&nbsp;showing&nbsp;24 hours...Maybe my problem gets clearer with the following example for my target state:"Target state"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;What I want is a date-based&nbsp;view showing values by the actual time they occured&nbsp;on that day.E.g. sensor data, where I get many different values per day.&nbsp;What I am able to produce at the moment is only a date-based view with average day values....&nbsp;Best regards,Flo

mim · Answer

I have the same issue, I end up combining date and time in the same column ( which is a bad practise as it increase the size).

simply put, in PowerBI i can not find a way to show a continous axis that show date and time

Forum Discussion

Date/Time drilldown

3 Replies

Related content

Date/Time

date/time addition

Extract date from date and time

Date TIme Change

date time format