Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

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

BlueWhite111_0-1673729071258.png

 

Sample Data

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

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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...

BlueWhite111_0-1673729584243.png

 

View solution in original post

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

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

Greg_Deckler_0-1673729415350.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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...

BlueWhite111_0-1673729584243.png

 

@Anonymous I would use something like this: Better Rolling Average - Microsoft Power BI Community



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.