Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |