Forum Discussion
Power Participanttick label missing in charticulator
I'm trying to create a column chart in charticulator. My data starts from Jan. 3rd and ends on June 30th. In X axis, I populated date, for some reason, Jan. is not appearing in x axis label. I would also like to change the tick label to central alignment (currently left alignment). Thanks for help!
Burningsuit Thank you for the detailed explanation. Indeed the date seems to cause errors when it's populated to x axis or text label, the date is always 1 day less than the correct value.
I find two solutions: 1) if users want to show date as a text label, they should use DateAsInteger instead of Date in the text field. In the chart below, I have created two text label, the label on the buttom use Date, which is not correct, the label on top use DateAsInteger which is correct.
2) in the text field, user can still use Date, but they should manually add 86400000 to the date value, in this way, the text label will automatically add 1 day to the default date.
6 Replies
- Burningsuit
Resident Rockstar
Hi Jeanxyz
This is because Charticulator creates a numerical X-Axis if you use a Date type field. So what you need is a categorical field on the X Axis. To do this, drag “Month” (under DATE) onto the X-Axis, not “DATE”:
That will get the months correctly on the X-Axis, but in alphabetical order, so edit the Sort order of the Month names, simply drag and drop them into the right order. You could also decrease the Gap between the months if you want to:
The chart should be useing a "Stack X" sub-layout which is created when you use the “Month” field, not an "Overlap" which is the default for numeric fields.
Hope this helps!
Stuart
- Jeanxyz
Burningsuit Thank you for the detailed explanation. Indeed the date seems to cause errors when it's populated to x axis or text label, the date is always 1 day less than the correct value.
I find two solutions: 1) if users want to show date as a text label, they should use DateAsInteger instead of Date in the text field. In the chart below, I have created two text label, the label on the buttom use Date, which is not correct, the label on top use DateAsInteger which is correct.
2) in the text field, user can still use Date, but they should manually add 86400000 to the date value, in this way, the text label will automatically add 1 day to the default date.
Hi Jeanxyz ,
As I tested in my side, I also had the same problem with you about tick label display(without January). Maybe you change the Start option in below screenshot is before Jan 1,2022(For exampe: Dec 20,2021)...
And for changing the tick label to central alignment (currently left alignment), which part do you want to change? The legend?
In addition, you can contact custom visual support team to get professional help.
Power BI Custom Visuals' Community
Best Regards
msftrienMicrosoft Employee
Thanks all for bringing up the issues. We’ve been facing issues with how Charticulator handles DateTime values for a bit now, and we’re working on getting the right dev on it. Sorry the problems have been around, and thanks for your patience.
- Jeanxyz
I don't think it's the tick counts (minimum tick is 30 in my case). it's related to date is not calculated correctly when it's populated to x axis.
