week over week analysis

[Jonjon_99]

Hi folks,

I am trying to find a solution for how I can show the trend between two products that were launched. One was launched in 2023, and the other in 2024. 
link of file
https://drive.google.com/drive/folders/1DzeXLls-WMIQBmyVE9c0MM5evtswqxcT?usp=drive_link



@johnyip 

[wini_R]

Hey @Jonjon_99,

Perhaps this setup would be helpful in your scenario. You can switch to clustered column chart, add Year as a legend and use Items as a custom tooltip

[Jonjon_99]

hey Wini, i need to see the difference between item. cause i need to identify the gap between the items per workweek.

[wini_R · Accepted solution]

In that case a custom visual might work better, i.e. clustered stacked column chart. You would need to create 2 separate measures for each year (example below) and align legend colors.

Units Prev Year = 
CALCULATE(
    SUM(ItemLaunch[Units]),
    KEEPFILTERS(ItemLaunch[Year] = "FY2023")
)

[Jonjon_99]

this looks good! can you share the file you made?

[wini_R]

Sure, please find the file here: https://www.dropbox.com/scl/fi/b3q2c4og884iclwrps8p8/ItemLaunchWoW_Comparison_2.pbix?rlkey=4chkut9qc...

[Jonjon_99]

updated file link
https://drive.google.com/drive/folders/1DzeXLls-WMIQBmyVE9c0MM5evtswqxcT?usp=sharing

thanks!

[wini_R]

Hey @Jonjon_99,

The link to your file does not seem to work, it says I have no permission to access it. Can you please fix it?

[Jonjon_99]

hi Wini sorry i forgot to public the file. this is the new link

https://drive.google.com/drive/folders/1DzeXLls-WMIQBmyVE9c0MM5evtswqxcT?usp=sharing