Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Getting all the values on X-axis

Hi Everybody, 
I have some data showing the number of downloads and the downloads type for the weeks in this quarter. As we are in the 10th fiscal week and have data only upto the 9th week, it shows only upto 9 on the axis, like the image below. 

But I need to see all the 13 weeks on the axis and values only upto 9. So I set start and end values from 1 to 13 but they are in intervals of 5, like the image below. How can I see all the week numbers on the x-axis?

Thank you!

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,
    In my tests, I found that the problem is related to the size of your screen, which is automatically displayed, which means how many Numbers can be displayed on the X-axis, depending on how big you can pull the chart up to.

     

    But if you have 13 data of weeks, you can do like this:

    Best Regards,

    Lionel Chen

     

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hey v-lionel-msft ,
      Thanks for your response. I have a lot of space for the visual and I am aware of the catergoriacal option. The problem arises when I add a legend of "Media Type" to it. Imagine we are in the 9th week and the rest of the weeks are future dates. I want the future dates to have "0" values, but it should be visible on the x-axis

       

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi Anonymous ,
        Is this what you want?

        Add three rows in data source:

        In addition, I couldn't find a more effective way.

         

        Regards,
        Lionel Chen