cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
natemarshall Frequent Visitor
Frequent Visitor

View Categorical Data Type in a Line Chart Condensed

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

 

7 REPLIES 7
Microsoft v-jiascu-msft
Microsoft

Re: View Categorical Data Type in a Line Chart Condensed

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.

View_Categorical_Data_Type_in_a_Line_Chart_Condensed

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
natemarshall Frequent Visitor
Frequent Visitor

Re: View Categorical Data Type in a Line Chart Condensed

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.

Microsoft v-jiascu-msft
Microsoft

Re: View Categorical Data Type in a Line Chart Condensed

Hi @natemarshall,

 

The link is invalid.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
natemarshall Frequent Visitor
Frequent Visitor

Re: View Categorical Data Type in a Line Chart Condensed

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.

 

Yield Trend.JPG

 

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

Microsoft v-jiascu-msft
Microsoft

Re: View Categorical Data Type in a Line Chart Condensed

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.

View_Categorical_Data_Type_in_a_Line_Chart_Condensed2

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
natemarshall Frequent Visitor
Frequent Visitor

Re: View Categorical Data Type in a Line Chart Condensed

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.

Microsoft v-jiascu-msft
Microsoft

Re: View Categorical Data Type in a Line Chart Condensed

Hi @natemarshall,

 

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

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors