Forum Discussion

Polygon's avatar
Polygon
Helper I
6 years ago

Line Chart X-Axis

I have a line chart that when filters the X-Axis (Which are month-YR) omits some of the labels, I assume because of space.

 

I tried to increase the size of the Line Chart; it helped a little; some of the labels showed; but some were still missing

 

So for example, Looking at 2020 line chart; Feb 2020, Mar 2020, Apr 2020, May 2020 etc. show but Jan 2020 doesn't?

2019 shows Jan 2020 Apr 2020 Jul 2020 Oct 2020 etc

 

How do you force to show all months?

 

Consumer wants to show all months.  Validated that each month does have data associated with it, it shows in the cart; just the label isn't there.

 

Has anyone run into this before?

 

Pictures attached

 

Thank you for your assistance in advance

Need Help

7 Replies

    • Polygon's avatar
      Polygon
      Helper I
      6 years ago

      It is Categorical.

       

      I even tried switching to Summary and then back; same result...  

       

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Polygon ,

         

        Categorical should have solved your issue. Because I see that working at my end.

        Can you share your pbix file removing any sensitive information?

        Also is your x-axis a datetime value rather than just Date?

         

        Thanks,

        Pragati

         

         

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Polygon ,

     

    Click on your chart, go to format options, under x-axis, make your axis CATEGORICAL.

    This should resolve your issue.

     

    Thanks,

    Pragati