cancel
Showing results for
Did you mean:
New Member

## Week over week line graph comparing Q1 vs Q2 data?

Hello,

I am trying to create a line graph that compares weekly data in Q1 vs Q2. I have created a custom column for Week of Quarter and created separate measures to compare each quarter. My current line graph is getting the correct total figures but is ignoring the time series context and just giving me a flat line. Image below.

Here is an example of one of the measures I'm using:

Q1 DemGen Total =
CALCULATE([DemGenTotal],
DATESINPERIOD(
Date_Lookup[Date],
DATE(2022,01,01), 1,QUARTER))

I believe the measure context is overruling the context from the x-axis. I think I need to make some edits to the above measure but I'm not sure what I'd need to change.

Anybody able to lend some insight?

Thanks!

1 ACCEPTED SOLUTION
Community Support

According to your description, I create a sample and it can get the correct result by your formula.

I guess it may be a matter of week of quarter or [DemGen Total] measure.

I attach my sample below, you can see what's different from yours.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

According to your description, I create a sample and it can get the correct result by your formula.

I guess it may be a matter of week of quarter or [DemGen Total] measure.

I attach my sample below, you can see what's different from yours.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

@jonfrank3366 , Just create a measure for this Qtr vs last qtr

Last Qtr =
var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _max = eomonth(_max,-1* if( mod(Month(_max),3) =0,3,Month(_max)))
var _min = eomonth(_min,-3)+1
return
CALCULATE([net] ,Filter('Date','Date'[Date]>= _min && 'Date'[Date] <= _max))
//Or use all
CALCULATE([net] ,Filter(all('Date'[Date]),'Date'[Date]>= _min && 'Date'[Date] <= _max))

Qtr =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = eomonth(_max,-1* if( mod(Month(_max),3) =0,3,Month(_max)))+1
return
CALCULATE([net] ,Filter('Date','Date'[Date]>= _min && 'Date'[Date] <= _max))

or trailing qtr for last qtr

New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

Announcements