cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
teckchan
Helper III
Helper III

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. downloads by media type1.PNG

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?downloads by media type.PNG

Thank you!

3 REPLIES 3
v-lionel-msft
Community Support
Community Support

Hi @teckchan ,
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.

d6.PNGd7.PNG

 

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

d8.PNGd9.PNG

d10.PNG

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.

 

 

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

 

Hi @teckchan ,
Is this what you want?

c17.PNG

Add three rows in data source:

c18.PNG

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

 

Regards,
Lionel Chen

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors