Forum Discussion

cusecuse315's avatar
cusecuse315
Regular Visitor
6 years ago

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

    • cusecuse315's avatar
      cusecuse315
      Regular 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