Forum Discussion

natemarshall's avatar
natemarshall
Frequent Visitor
8 years ago

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 Con...
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi natemarshall,

       

      The link is invalid.

       

      Best Regards,

      Dale

      • natemarshall's avatar
        natemarshall
        Frequent Visitor
        8 years ago

        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