Forum Discussion

MARMAXCHEROT's avatar
MARMAXCHEROT
Frequent Visitor
1 year ago
Solved

Data Visualization - Timeline (Dashboard)

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 varia...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.