View Categorical Data Type in a Line Chart 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-jiascu-msft]

Hi Nate,

If you want a monthly graph, you can drill down to month as the picture shows.

If you want more help, please provide a dummy sample.

Best Regards,

Dale

[natemarshall]

Oops this accidentally got posted twice.  Here is the original post.

https://community.powerbi.com/t5/Desktop/Show-Categorical-Data-Trend-Condensed/td-p/322289 

This one can be deleted.  Thanks.

[v-jiascu-msft]

Hi @natemarshall,

The link is invalid.

Best Regards,

Dale

[natemarshall]

That is confusing, apologies.  Here is my follow up from the other thread.

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

[v-jiascu-msft]

Hi Nate,

If you are only interest in the trend. Why not changing the type of X-axis to Continuous and the visual will be condensed.

If you still want this feature, please create an idea here.

Best Regards,

Dale

[natemarshall]

I am not interested in Continuous because it interpolates.  It sounds like Power BI is not able to have a responsive line chart in the "Categorical" X-Axis Type yet, and that's fine.  I can pull my data into Excel and get my result with the "Text Axis" type in Excel.

Thanks.

[v-jiascu-msft]

Hi @natemarshall,

If you want this feature, please create an idea here.

Best Regards,

Dale