Showing Representative Sample for Continuous Linear Date Axis

[cusecuse315]

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?

[Anonymous]

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.

Too many Values warnings

Resolving Power BI Report Warning – Too Many Values Not showing All Data

Best Regards

Rena

[cusecuse315]

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