Forum Discussion
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
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...
Anonymous Yes, use a Custom Format String in the Modeling view dd-mmm
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...Anonymous I would use something like this: Better Rolling Average - Microsoft Power BI Community