Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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?
Hi, just checking to see what the solution to this was. I have a similar problem.
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,
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
User | Count |
---|---|
88 | |
74 | |
69 | |
59 | |
56 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
28 |