Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
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 @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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |