Forum Discussion

karimk's avatar
karimk
Helper III
8 years ago

Bar Chart Missing X Axis Labels

Hi,
I have a bar chart that shows the ammount of things I have to do per month, over the next 2 years.

My X axis is missing some labels, although I still get the bar.

 

If I change my X axis type to categorical, it will show the labels correctly, but not all months, even if I choose to show items with no values.

 

My excel database is as shown.
Any suggestions?




 

Need Help

3 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    karimk

     

    Can you try "show items with no data" when you select "Contiuous" on X-axis?

     

    In chart visuals, when you select "Contiuous" and put a date field, it supposes to detect the date hierarchy and generate continuous dates on X-axis. 

     

    If you select "Categorical", it will only show items which exists in your source table.

     

    Regards,

    • karimk's avatar
      karimk
      Helper III
      8 years ago

      Hi, thank you very much for the response. I actually didn´t upload a pic of the chart with bars showing, but no label.

      Here it is. This is not date hierarchy, with a continuous x axis configuration and "show items with no data"

      As you can see, the month of February 2018 has a bar with 1 item, but the label for "Feb 2018" is not showing

  • jdubs's avatar
    jdubs
    Helper V
    3 years ago

    Hi, just checking to see what the solution to this was. I have a similar problem.