Forum Discussion
Solved
Date formatting in a graph created with the data model
Hello, I hope this will not be off topic, but I can't find any answer about this oh-so-small problem that is driving me mad. I have data which I prepared with Query, which I use with the data mo...
you can add a calculated column of YearMonth with the formula =format([date],"mm/yy")
then put it on the vertical axis
you can add a calculated column of YearMonth with the formula =format([date],"mm/yy")
then put it on the vertical axis
Yup, worked perfectly! I didn't think it would be necessary to add a column in my data model, but it does the trick without slowing down the database.
Thank you!