Forum Discussion
Scatter chart X axis date not ranking
As shown the dates are not showing up as i want it to be. Like it's repeating. What's the reason for that?
(start with 2022, and 20218, 2021 2021, start reapperaing in between)
Thanks!
14 Replies
Uzi2019Community Champion
Hi Anonymous
I think the column you are choosing are not Date data type. it is i think text data type.
Please correct it to date data type. follow the instruction:under column tools you will find these option where you can find data type setting, and different format as well.
If my post helps you please give kudos and accept my solution!
Thanks- Uzi2019
Hi Anonymous
This issue of repeating date will be resolved by calendar table.
Please create a Calendar table (takes 3 mins). follow these steps:
Go to modelling tab > New tableCreate following formula
Calendar = CALENDAR(MIN(Investment date),MAX([Investment date]))
Your New Calendar will be created.
Now link you Calendar date with Investment date( Cretae Relationship).Take date from Calendar date into you scatter chart visual.
you will not see repeative date.
If my post helps you. Please give kudos and accept as a solution!
Thanks.- Uzi2019
HI Anonymous
follow the proper instructions.
I've mentioned to take New Table and Create Calendar calulation.
But you have taken the Calculated Column. That's why throwing an error.