OK, so Power BI Desktop does not allow Date and DateTime fields in the Y-Axis. But you can get around this with some simple DAX and Custom Format Strings. Well, sort of, once they fix this bug I submitted: Y Axis Custom Format String Issue - Microsoft Power BI Community.
Set your Sort By column to your original Date column:
DatesInY = MONTH([Date]) * 1000000 + DAY([Date]) * 10000 + YEAR([Date])
DateTimesInY = MONTH([Date]) * 1000000000000 + DAY([Date]) * 10000000000 + YEAR([Date]) * 1000000 + HOUR([Date]) * 10000 + MINUTE([Date]) * 100 + SECOND([Date])
Custom format string for DatesInY is: 00\/00\/0000
Custom format string for DateTimesInY is: 00\/00\/0000 00:00:00
Thanks once again Chelsie Eiden!!
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Mastering Power BI 2nd Edition
DAX is easy, CALCULATE makes DAX hard...
