5-year average and year average % in 1 visual, seasonality
Hello Folks, FreemanZ Jihwan_Kim Dangar332 123abc I have the daily data from 2018, and I would like to see the yearly seasonality in % with the 5-year average %. x axis: months y axis: % Legend: probably years from date?: 2018, 2019, 2020, 2021, 2022, 2023 (this one until nov) + 5-year avg I can make these work on separate visuals, but I can't integrate them into one. 5-year avg calc measure is included in the file. The desired visual format is also in the file. Measure for 5-yr avg: 5Y_AVG_Corn = AVERAGEX ( SUMMARIZE ( FILTER ( 'Corn_Prices', YEAR ( 'Corn_Prices'[date] ) >= YEAR ( TODAY () ) - 5 && YEAR ( 'Corn_Prices'[date] ) < YEAR ( TODAY () ) ), 'Corn_Prices'[date].[Year] ), CALCULATE ( SUM ( 'Corn_Prices'[ value]) ) ) Data: corn_prices_pbiforum.xlsx Visual mockup: (data of 2023 would finish in November)
