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 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

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

      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

      • natemarshall's avatar
        natemarshall
        Frequent Visitor
        8 years ago

        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.