Unable to display all days in a matrix

[dennisshelton]

I know someone knows this answer and has likely posted it several times, but I'm not able to locate it. I have a report which contains a matrix of appointment status rows with dates as the columns. I have it defaulting to display the last 30 days not including today, but the problem is when the default filter is removed for the last 30 days it only shows around 100 - 120 days (columns) and defaults to the beginning on the record set which is the beginning of this year.

The slicer I added is working to allow access to other dates ranges, but when I remove the filter it will still only display around 100-120 days.

Is there a setting or limitation of Power BI to restrict the loading of the date ranges for data?

Thanks in advance,

Dennis

[RobbeVL · Accepted solution]

Here you go:

https://lmgtfy.com/?q=column+limit+matrix+power+bi