Forum Discussion
Jonjon_99
Helper I
Helper Iweek 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") )
