Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Tricky - Date Format - in line graph

Hi Experts

 

Is it possible to have a date format as shown in the image on a line graph

 

Sample Data

https://www.dropbox.com/s/eg6v05dpsfeayzl/Test__.pbix?dl=0  

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Greg....Ok how would you plot that on a 7 day moving average...

     

    My DAX is

    Rolling =
    CALCULATE (
        SUM ( FACTData[Congestion Delay Index: Vancouver] ),
        DATESINPERIOD ( 'DimDate'[Date], LASTDATE ( 'DimDate'[Date] ), -7, DAY )
    )/7
    The shape of the is right but i cannot get the x axis to work with the plot when using dd mmm as you have point out...

     

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous Yes, use a Custom Format String in the Modeling view dd-mmm

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Greg....Ok how would you plot that on a 7 day moving average...

       

      My DAX is

      Rolling =
      CALCULATE (
          SUM ( FACTData[Congestion Delay Index: Vancouver] ),
          DATESINPERIOD ( 'DimDate'[Date], LASTDATE ( 'DimDate'[Date] ), -7, DAY )
      )/7
      The shape of the is right but i cannot get the x axis to work with the plot when using dd mmm as you have point out...