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 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
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") )this looks good! can you share the file you made?