Stacked Column Chart with PY and CY view

Hi Anonymous ,

I'm not quite sure what you need. Do you want to apply two different slicers to filter the current year and previous year's values for the same period separately? Could you pleae share your demo pbix file with us? And explain the related scenario(backgroud and calculation logic etc.) and final expected result with specific examples. Thank you.

In addition, here are some links about comparing current year and previous year's values, you can refer to them.

CREATING A POWER BI CHART COMPARING EACH YEAR VS PREVIOUS YEAR

This Year VS Last Year Time Comparisons & Differences In Power BI

Best Regards

Also, I forgot to mention, I can get it to work with a cluster column chart with the dynamic slicer at the top. I'm trying to enhance the view with a stacked column chart adding the Flag (Yes and No) by year 2020 vs 2021 in a stacked column chart. More details in the attached .pbix.

Hi Anonymous ,

I can't download your file due to I have no proper permission... You can refer the method in the following link to share the file with me. Thank you.

Best Regards