Forum Discussion

dparkinson's avatar
dparkinson
Advocate I
9 years ago

Streaming Dataset DateTime Field Date Hierarchy Missing

I've previously asked this in the developer forum, but it's a little quiet over there, so I thought I'd try here too -- hope that's ok...   I have a streaming dataset with a DateTime field. The str...
Need Help
CahabaData's avatar
CahabaData
Memorable Member
9 years ago

I don't have a streaming data set but maybe this will be the same: in Dataset - starting with a blank canvas, select your date field from the right Fields pane so it shows up in the canvas

 

then in the Visualization pane, look at it's drop down and see if Date Hierarchy is checked.......

 

 

  • dparkinson's avatar
    dparkinson
    Advocate I
    9 years ago

    Hi, thanks for the response.  Yes, that's the point, that option is missing...

    • CahabaData's avatar
      CahabaData
      Memorable Member
      9 years ago

      any chance the field is coming is a text field?  any strange alpha mingled in to make PBI think it is text?

      • dparkinson's avatar
        dparkinson
        Advocate I
        9 years ago

        So, to be clear, this is a streaming dataset with the field set as a DateTime field.  When shown on a live tile, it shows the data updating every 30 seconds (as that is how often I'm updating the data), so the field is recognised ok as a date time field.  It's just that when I put the field onto a normal report (rather than realtime), date hierarchy is not an option so that I can view average stats over a day/week/month/year etc.

         

        I hope that's clearer.