Forum Discussion
Solved
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.googl...
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") )
updated file link
https://drive.google.com/drive/folders/1DzeXLls-WMIQBmyVE9c0MM5evtswqxcT?usp=sharing
thanks!