Forum Discussion
Showing Representative Sample for Continuous Linear Date Axis
Hi,
I am trying to show single patient sub-status over time by using a bar chart with a continuous linear x-axis from Date[full_date] but it is not producing the chart saying "There are too many 'Full Date' values. Showing Representative Sample. Filter the Data or choose another field."
My data is set up with a value per patient per day and the y-axis is just a distinct count of patient (so its always 1). Whats weird is that on the same page using the same table, it is populating for Status, but the sub status is not populating. Looks fine in desktop but does not render in Serviceerror messageMissing bars because it is showing representative samplesame exact chart but using Status instead of sub-status renders without issue.
Using Live Connection to SSAS tabular model.
Table looks like (also related to DimDate and can pull date from there):
Full Date Patient ID Sub-Status
6/1 A Pending Appeal
6/2 A Pending Appeal
6/3 A Waiting for Docs
6/3 B Pending Appeal
6/3 C Waiting for Docs
The visual is for a single patient, and were only talking about 6 months of data, i dont get whats the issue here
Is there a way around this?
2 Replies
- AnonymousNot applicable
Hi cusecuse315 ,
It seems that you have applied too many values on the X axis label of visual, it may result in the display of this warning message. Is there a lot of dates corresponding to each Status? You can check the following threads which have similar problem with you for more detail and get the solution from there.
Resolving Power BI Report Warning – Too Many Values Not showing All Data
Best Regards
Rena
- cusecuse315Regular Visitor
Hi Anonymous ,
It is only about 4 months of dates, so about 120 dates, and theres only one row per date, so only about 120 rows.
The other chart on the page uses the same table but renders everything correct, the only difference being the one giving the error has more categories in the Legend