Forum Discussion

Fraze's avatar
Fraze
Helper I
3 years ago
Solved

PowerBI Visualizations Forcing Full Year Date Range

Hello,

 

Really confused on this one.

 

My Raw Data has dates from from Jan 1, 2020 to Jan 1, 2023

 

My Date Table runs from Jan 1, 2020 to Jan 1, 2023 

 

However, when I try to create a chart, it forces the full year....

 

It is probably from the measure I am using:

 

CALCULATE(SUM('3-IncomeStatment'[postingamount]),REMOVEFILTERS('1-Calendar'),DATESBETWEEN('1-Calendar'[Date],[StartofYear],[MaxDate])
 
But even though I am removing the date filter, my MAX date in 2023 is still January? Why is it forcing full year visualizations?

 

 

 

1 Reply