Show Categorical Data Trend Condensed

[natemarshall]

Hello,

I am trying to show the trend of a test result of a manufactured product over time.  I am using the Line Chart, and my problem is that I want to use Categorical Type on the X-axis, not Continuous Type.  It may be days or weeks before the same product is run, and Continuous interpolates in between.  Categorical will show each test result with a timestamp, but for hundreds of data points this can cause quite a long scroll bar.  I want it condensed so I can see months of data and analyze the trend.

The data is being stored as a Quantity (53.5), and Date/Time (2017-12-11 15:54:06.957).  

Is this possible?

Thanks, Nate

[v-sihou-msft]

@natemarshall

When using "Continuous " type, it will always populate a full calendar dates on X-axis. So the line may not appear correctly. And for "Categorical" type, it will show all entries on X-axis.

For your requirement, I suggest you manually create a Calendar Hierarchy like "Year->Quarter->Month->Day". You may add some calculated columns for each date parts like: Year, YearQuarter, YearMonth, Date.

Then you just need to put entire hierarchy into Line chart, and you can drill to any level you want. 

Regards,

[natemarshall]

Hello,

Thank you for the response.  I am not looking to drill down into a time heirarchy.  I would like to show all entries on the X-axis, but responsive to window size of the chart.  I pulled the data into Excel, and was able to achieve my result.

When I resize the Excel chart, it will still show me all the data points.  Perhaps not as granular, but I am only interested in the trend.  In Power BI, the chart does not "condense" the results.  It adds a scroll bar and I must scroll to see all results.

Does this help?

Thanks,

- Nate