Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Tricky - Date Format - in line graph
01-14-2023
12:44 PM
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
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-14-2023
12:53 PM

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

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 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-14-2023
12:50 PM

@Anonymous Yes, use a Custom Format String in the Modeling view dd-mmm
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-14-2023
12:53 PM

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

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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-14-2023
01:05 PM

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

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
07-15-2024 07:13 PM | |||
03-10-2024 11:31 PM | |||
07-25-2024 06:34 AM | |||
04-25-2024 07:28 AM | |||
03-03-2023 01:05 PM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
128 | |
119 | |
84 | |
59 | |
47 |