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

[Ohhhhhhfffs]

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

UID	SampleValue	Date	OtherRandomData
SS001	90	1/1/2020	afasfasfa
SS002	70	1/1/2020	fasfaasf
SS003	100	3/3/2021	asasfasf
SS004	30	2/4/2021	asfasfsa
SS005	80	4/4/2022	fasasfasfasf

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?

[amitchandak]

@Ohhhhhhfffs , These are the data limits

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-data-points

Move both the axis and legend on the axis. Sort of axis and use concatenate label -off

That will reduce data a bit , see if that can help

Concatenate Label off : https://youtu.be/QgI0vIGIOOk