Need help with YOY line chart

[MilindG]

Hello Community!

I'm very new to the Power BI and I need your help creating a year over yer comparision line chart.

At the moment I have created a line chart however for the PY it shows full year whereas I only want it to display same yearweek as current.

Another thing I need help with is creating a calculation field  'Change' which calculates the difference beween CY sales vs LY sales YTD (LY should only go upto max this years week. ). My data shows weekly and end of last week. I want the YTD total to display CY, and LY should be end of prior week LY(08/13/2022)

Below is how somewhat my data displays

Id really appreciate any help. Thank you!

[MilindG]

@ryan_mayu  Thank you again. This solved my problem.

[ryan_mayu]

you are welcome

[MilindG]

@ryan_mayu  Sorry for the late reply. This is exactly the format I was looking for. I need one additional thing changed and need your help with. My current data is looking YTD and ends last Sat. So for the current report, it should have data from 1/1/23 - 9/2/23. I want the PY to be compare the same time period(Week) so itd be 1/2/22 - 9/3/22 if that makes sense.

[ryan_mayu · Accepted solution]

@MilindG 

you can create a scope column, then only do the calculation when scope is y

pls see the attachment below

[MilindG]

@ryan_mayu Hello I have one more question. Similar to here where you helped me get yoy data for same date time. How would the forumla change if I'm bringing one more year(2021) I'm looking to compare same timeframe for current year, Previous year and PPY.

'

scope =

VAR _year=year('Table'[Week End])

VAR _py=EDATE(TODAY(),-12)

RETURN IF(_year=YEAR(TODAY()) || _year=year(today())-1 && 'Table'[Week End]<=_py,"y")'

I'm struggling to add the forumla for the PPY

[ryan_mayu]

@MilindG 

maybe you can try this

scope =

VAR _year=year('Table'[Week End])

VAR _py=EDATE(TODAY(),-12)

VAR _ppy=EDATE(TODAY(),-24)

RETURN IF(_year=YEAR(TODAY()) || _year=year(today())-1 && 'Table'[Week End]<=_py||_year=year(today())-2&&'Table'[Week End]<=_ppy,"y")

[MilindG]

@ryan_mayu Excellent!! This is exactly what I was looking to do. Thanks a lot for all your help!

[ryan_mayu]

you are welcome

[MilindG]

@ryan_mayu  Sorry to bother you again, I have one more question.

Mine doesnt show up in this order. it show up Change, PY, CY, Change% or like below

I tried dragging it or rearranging but its not working. How do I get these in the order like yours?

Also how do I get rid of the decimals and round up?

[ryan_mayu]

i have another order table which set up the orders. you can check the attachment i provided.

[MilindG]

@ryan_mayu 

Site	Year	Week End	YearWeek	Name	Amount	CY vs PY
1	2022	5/7/2022	18	AAA	500	PY
2	2023	5/6/2023	18	BBB	100	CY
3	2022	5/7/2022	18	CCC	300	PY
3	2022	5/7/2022	18	EEE	350	PY
3	2022	5/7/2022	18	AAA	100	PY
2	2023	5/6/2023	18	BBB	500	CY
1	2022	5/7/2022	18	BBB	750	PY
1	2023	5/6/2023	18	AAA	600	CY
2	2022	5/7/2022	18	AAA	150	PY
1	2023	5/6/2023	18	EEE	35	CY
3	2022	5/7/2022	18	AAA	95	PY
1	2022	5/14/2022	19	EEE	160	PY
3	2023	5/13/2023	19	AAA	285	CY
2	2022	5/14/2022	19	EEE	125	PY
2	2023	5/13/2023	19	EEE	150	CY
2	2022	5/14/2022	19	CCC	200	PY
1	2023	5/13/2023	19	EEE	450	CY
1	2022	5/14/2022	19	CCC	365	PY
1	2022	5/14/2022	19	AAA	250	PY
2	2023	5/13/2023	19	BBB	950	CY
2	2022	5/14/2022	19	BBB	1000	PY
3	2023	5/6/2023	18	CCC	350	CY
2	2023	5/13/2023	19	CCC	625	CY

Heres my sample data. I already have this dashboard on Tableau and I'm trying to recreate it on PowerBI. Below is a snip of what I'm trying to get

At the moment I have the line chart created however I'm unsure on how to create the red boxed section which displays current year total(YTD), PY total(YTD total as same yearweek as CY), Change in $ and change%.

[ryan_mayu]

@MilindG 

here is a wordaround for you

you just need to change the name filter to create the box for other names.

[ryan_mayu]

could you pls paste the sample data (not the screenshot) and also provide the expected output?