Forum Discussion
week over week analysis
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
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") )
8 Replies
hi Wini sorry i forgot to public the file. this is the new link
https://drive.google.com/drive/folders/1DzeXLls-WMIQBmyVE9c0MM5evtswqxcT?usp=sharing
updated file link
https://drive.google.com/drive/folders/1DzeXLls-WMIQBmyVE9c0MM5evtswqxcT?usp=sharing
thanks!hey Wini, i need to see the difference between item. cause i need to identify the gap between the items per workweek.
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") )