Forum Discussion
Data view - date display formats
I seem to be running into a problem I was previously having here: https://community.powerbi.com/t5/Desktop/Default-sort-column-of-table-in-report/td-p/63901 I thought I had it solved there but I...
Thanks v-ljerr-msft yes that works and I had thought of it but I am still hoping there may be a more integrated way of acheiving this rather than having an entirely separate field, after all the day is part of the date and it would be disappointing if MS have not provided a means to configure the display of it outside of their supplied formats.
Sorry for the late reply.
I just added one more column called DateKey in the FactTable which is defined as
DateKey = (Year('FactTable'[DateTime])*10000+Month('FactTable'[DateTime])*100+day('FactTable'[DateTime]) )
Then set the DayDateTime to be sorted by this and I had no issues.
Check it out it should work.
CheenuSing