Too many values (Showing Representative Sample) on a Stacked Column Chart

Hi,

I have a simple dashboard that looks like the following

However i cannot see all the values, i get the errors (Too many values or Showing Representative Sample)

I have two data sources, one is a Date source made using the Autocalander which i use on a splicer to filter the following data in my other source that looks like the sample below is stored in SQL, there is only 1500 or so rows each with a unique UID

It is a stacked column chart

The X Value is Date,

The Y Value is Sum of SampleValue

and the Legend is UID

How am i able to view all the data in the dashboard? Surely Powerbi can handle more?