Forum Discussion
Date/Time drilldown
Resident RockstarHi Flo,
If I understand your reqirement correctly that you want show the value with their actual date and time.
If it is, you could add two fields to the axis, one for date and one for time.
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.
2.To drill down one field at a time, select one of the elements in your visualization.
Reference: Drill Down
If you need additional help please share some data sample and expected output.
Best Regards,
Cherry
Hi v-piga-msft,
thank you for your answer!
I think my problem is a bit different:
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 I lose the reference to the date and only get a time axis showing 24 hours...
Maybe my problem gets clearer with the following example for my target state:
"Target state"
What I want is a date-based view showing values by the actual time they occured on that day.
E.g. sensor data, where I get many different values per day.
What I am able to produce at the moment is only a date-based view with average day values....
Best regards,
Flo
mimAdvocate V
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
