So I have a graph and I want it to show the date of the day but it's showing a number series 1-30.
What I want is the date along the bottom and not a number. It works fine with weeks or months by change it to a day and it puts a number. Any ideas?
Go to Solution.
Use the following Formula instead of using the date.
Day = FORMAT(Table[Date], "MMM DD")
You'll need to use a DateTime field on your chart axis, rather than an Integer field.
Proud to be a Datanaut!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.