PowerBI Visualizations Forcing Full Year Date Range

[Fraze]

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?

[Anonymous · Accepted solution]

Hi @Fraze ,

Please remove the relationship between the tables.

I have created a simple sample, please refer to.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.