Forum Discussion
Line chart year issue
Wow, this is really interesting now. I got confused at first looking at that as I though that this must have been a DAX issue, that you arechanging the data context through DAX. But then I realised that we can try the following:
1) Set the X-Axis to Continuous
2) Make sure your Date column data type is Date and not text. This step should be done before step #1.
3) If you are not using a distinct dim_date_table, I would create one and connect it to the fact table.
I hope this helps. 😊All the best,
Michael
Wow, this is really interesting now. I got confused at first looking at that as I though that this must have been a DAX issue, that you arechanging the data context through DAX. But then I realised that we can try the following:
1) Set the X-Axis to Continuous
2) Make sure your Date column data type is Date and not text. This step should be done before step #1.
3) If you are not using a distinct dim_date_table, I would create one and connect it to the fact table.
I hope this helps. 😊
All the best,
Michael
so the X Axis was set to continuous and I changed it to categorical and bingo...
I did have the turn off the labels as they were a bit ugly, but I can use this. Thanks!
