Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Date + Time

If you are to believe marcorusso ... when you have both date AND time... you should split them into seperate columns.  No arguments here.   However... I am having a hard time finding a visual exper...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks Dudes.

 

I don't disagree from a pure modeling standpoint, but once I go to create visuals it is not that fun.  Unclear though how related that is to separate tables.

 

I am mostly using a line chart -- I'm trying to show changes over time (maybe think... stock chart).  It works... vaguely ok.  At least I can place as many drill down fields as I want -- though only selecting a single point isn't great (I want to zoom in from 1:30 to 2:30... too bad).  And the axis labels get super ugly.

 

Some other visuals just don't support multiple fields (like, maybe 3rd party visuals...  pulse chart or zoom chart would be interesting, but they ONLY support a single field, presumably date, unless you build a date+time).

 

I mean compare it to :

http://dygraphs.com/

https://www.highcharts.com/demo/line-time-series

https://plot.ly/r/

 

I actually stumbled upon a msft beta site w/ nice time series graphing/zooming, but now I can't find it.  Didn't seem in any way related to Power BI but those teams should talk :)