Data Visualization - Timeline (Dashboard)

[MARMAXCHEROT]

Dear all, 

I have a table with data associated with a time column of type "Date and Time". When graphing the variable as a function of time, it does not allow me to see the evolution of the variable hourly (it only gives me the possibility of seeing year, quarter, month and day).

How can I make it allow me to expand the x axis (time) so that I can see the evolution, for example, per minute?

Regards,

[Anonymous]

Thanks for lbendlin's concern about this issue.

Hi, @MARMAXCHEROT 

I am glad to help you.

Maybe you can try the method provided by lbendlin , his method might work for you.

And if the Date/time type is not that important to you, you can also try to change the type to Text, like this, so that he can display the data by minutes properly:

I have attached the pbix file for this example below, I hope it helps.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Don't use a hierarchy, disable Auto Date/Time.  Then use the column for the X axis and let the visual renderer do the work for you.  You can use zoom sliders to zoom into areas of interest.

Most likely you will see the blue "i"  in the top right corner, indicating too many data points. Be aware that forced sampling is applied when the blue "i"  is shown.