Forum Discussion
Solved
Only getting random Data Labels
I needed to create a visual with a trendline that also shows only the last 24 months of data and a started with a visual that would not allow me to add a trendline. I learned that I must change my x ...
OhLookAnError , It seems like a continuous axis, make it categorical
if needed have month year and month year sort column in your table and use month year column
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
OhLookAnError , It seems like a continuous axis, make it categorical
if needed have month year and month year sort column in your table and use month year column
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c