Forum Discussion
X axis not aligned
The X axis months on my charts are not aligned with the bars. For example, "Jan 2017" is aligned under December data. And this will repeat itself next month and the month after. But with different months and newer data. Any ideas how to fix?
16 Replies
- BaskarResident Rockstar
Cool dude,
It is really miracle to see this am surprised.
Can u please share the data to validate.
My personal thinking : This is not possible to show like this.
Note :
U have to check with your data or relationship between.
Let me know if any help.
- cnpdxHelper II
not really comfortable sharing the file. but what kinds of possibilities do you see that could make this happen? im pretty sure my relationship between the dynamic date calendar and the sales table are correct.
Baskar wrote:Cool dude,
It is really miracle to see this am surprised.
Can u please share the data to validate.
My personal thinking : This is not possible to show like this.
Note :
U have to check with your data or relationship between.
Let me know if any help.
- alanhodgsonSolution Supplier
Hey cnpdx,
No need to share the file, but if you could share the relationship between the tables that would help. Also, how is the date column (used in the graph) formatted and what is the data type? Finally, I would look at the sorting on the date column, is it sorted by another column?
Hope this helps,
Alan
- mettansridharNew Member
Even im facing the same issue.
Have plot the Head count/Attrition (HR-Domain), but the FY which starts from April, but the X-axis is showing it as May, but tool-tip is correct, the first data point is from April.
- carlogazzaniRegular Visitor
same issue here, but when i switch to "categorical", it shows me the last day of the month.
In this case, the 'date' column is a calculated column
= coalesce(related(table1[date]),table2[date])
Over November, we can see numbers from October and so on...