Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Timeseries with individual observations

Hi!

I'm hoping to get some advice on how to tackle an obsticle regarding presenting individual observations based on dates.
I have a dataset containing both dates and a value x, wich I would like to present through a line chart.

 

The problem I face when making this graph in PBI, is that when there are several observations on the same date, the model adds those rows/values together and displays a false number for that obs/date. 


What I'm after (I think), is a way to link the line graph to observations and not date as some dates have more than one observation. However, I would like the model to also show the time-scope, so one gets a picture of development over time (although this could be on a per-month-basis, and not on a per-date-basis).

Any suggestions?

Best:

PJ   

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous,

     

    Kindly share your sample data and excepted result to me. As you said "although this could be on a per-month-basis" You can try to create a calculated column using the MONTH function to work on it. Something like that.

     

    Year month = FORMAT(Table1[DATE],"mmm") & "-"&YEAR(Table1[DATE])

     

    Regards,

    Frank

    • v-frfei-msft's avatar
      v-frfei-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi Anonymous,

       

      Does that make sense? If so, kindly mark the answer as solution to close the case.


      Regards,
      Frank

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello, v-frfei-msft.

        Thank you for the response. You're solution solves partially the problem, but my main goal is to display a graph showing each observation as an individual point on the x-axis.

         

        I dont have an index number and the observations only have a date assosiated with them. I could add an index number, but Im not interested in all observations, only a sub category of them, thus making this a bit tricky. When I use the dates as observations, It works fine until there are two or more observations on a single date as the graph aggregates the values (so instead of showing thre observations on the line with 1, 4, 2, it shows 1 point with the value 7).

        I understand that this problem is a bit nested, so I've rather posted anothter promlem that I think will solve this case neatly. Please weight in if you have a comment on this post.

        https://community.powerbi.com/t5/Desktop/Adding-index-number-based-on-category/m-p/546793

        Thanks for helping.

        Per.