Forum Discussion

Adam_089's avatar
Adam_089
Regular Visitor
3 years ago
Solved

Problems displaying a normal time series

Hi,

 

I have the following information and just want to get it displayed as a normal time series. With the date on the X axis and the value on the Y, but I am getting a really random line graph out of it.

 

DateCosts
01.01.202331,50
01.02.202363,00
03.03.202363,65
21.02.202365,25
13.03.202366,35
13.03.202367,25
09.03.202368,65
09.03.202370,05
09.03.202371,45
09.03.202372,85
09.03.202374,25
21.03.202375,25
21.03.202376,25
28.03.202377,25
28.03.202378,25
21.04.202378,90
21.04.202379,44
21.04.202379,47
21.04.202379,55
21.04.202379,55
28.04.202380,55
28.04.202381,55
28.04.202382,55
28.04.202383,55
28.04.202384,55
28.04.202385,55
28.04.202386,55

 

And the graph which I get from this is shown like this :

I have no idea where it's getting these numbers from, I have turned off the summarization to "don't summarize" but yet it seems to keep on giving me a running total, but with a blip in the middle (probably because there are many entries for that specific date, but then how can I get it that it just takes the maximum and ignores the others ?) I would expect it to be a straight upwards trend with no random up and down in the middle. Any help with this would really be appreciated ! 😊

 

 

 

 

 

Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    try using a measure for the costs column:

     

    Measure  = CALCULATE(MAX('Table Name'[Costs]),ALLEXCEPT('Table Name','Table Name'[Date]))
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

10 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    try using a measure for the costs column:

     

    Measure  = CALCULATE(MAX('Table Name'[Costs]),ALLEXCEPT('Table Name','Table Name'[Date]))
     
    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
  • Adam_089's avatar
    Adam_089
    Regular Visitor
    3 years ago

    Thanks, it's changed it, but now it's just basically a flat line over the time period only showing the maximum value and for dates in the future, which I shouldn't really show

     

     

     

  • aggiebrown's avatar
    aggiebrown
    Helper III
    3 years ago

    Hi Adam_089,

     

    It is best to create a measure, that will calculate your cost. I imagine you have a Date Table (where you are taking you're months from also).

     

    Simple measure like this should work: 

    Cost = CALCULATE(SUM(pbi[Costs]))
     
    If you then drop your month and the measure "Cost" - the graph should look the way you want to.
    Relationship between Date Calendar and your Cost Table:
     
    Hope this helps 😀