All year data in bar chart

[Ferha_Jafri]

Hello Experts,

I have a filter on my page of year, but I wanted to show all year in the bar chart. So on the same page have other graphs which should respond on year filter , but bar chart should show all the years present in the data as 2020, 2021 and 2023 although if 2020 is slected in the year slicer.

Premium_Year = CALCULATE(CALCULATE([Sum_Premium]),REMOVEFILTERS(Final_Table[effective_date].[Year]))

I have tried this expression but did not work.

[bhawanak · Accepted solution]

Try

CALCULATE(Table Name(measure you want),ALL(Year/Date field))

such as CALCULATE(Final_Table[Sum_Premium],ALL(Final_Table[effective_date]))