Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
eyJrIjoiNDMyNTkxZDItZWI4NC00NjhlLTk2NWQtNWY5YjY3YmM4NTkzIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9