Forum Discussion
Solved
All year data in bar chart
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.
Try
CALCULATE(Table Name(measure you want),ALL(Year/Date field))
such as CALCULATE(Final_Table[Sum_Premium],ALL(Final_Table[effective_date]))
1 Reply
Try
CALCULATE(Table Name(measure you want),ALL(Year/Date field))
such as CALCULATE(Final_Table[Sum_Premium],ALL(Final_Table[effective_date]))