Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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
Super User
Super User

Syndicated - Outbound

@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!:
Power BI Cookbook Third Edition (Color)

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

Syndicated - Outbound

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

 

Syndicated - Outbound

@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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
avatar user

Helpful resources

Announcements
FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)