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") )
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")
)