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...
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 👍
Adam_089's avatar
Adam_089
Regular Visitor
3 years ago

Ok, thanks, I don't quite know why, but when I deleted the graph and then reinserted it with exactly the same figures, it seems to have done more or less what I wanted to.

 

The only challenge now is to make the X Axis display properly. If I put it on anything less than a year in the date hierarchy it shows me a daily breakdown (that's on the monthly option on the hierarchy) any idea on how to change this to be just back to the months ? I can't see an option in the formatting

 

 

 

 

aggiebrown's avatar
aggiebrown
Helper III
3 years ago

You can use arrows up and down as highlighted to toggle between daily view and monthly view, depending on what you put on your X-Axis. Hope this helps.

  • Adam_089's avatar
    Adam_089
    Regular Visitor
    3 years ago

    Ah, doh ! Thanks, I totally forgot about that ! 😁

     

    • aggiebrown's avatar
      aggiebrown
      Helper III
      3 years ago

      No worries! Glad it helped! 😀