Forum Discussion
Date sorting
Hi, I've posted this quesiton previously, but still can't seem to solve the problem. I have a list of Facebook posts, which need to be ordered by the post date/time, but it is still orderin...
Hi Ormesome,
Thanks for your help!
The main date column in my post data is formatted as 'mm dd yyyy' (this is how it is in the excel) and my power bi locale settings are US.
Perhaps the problem is that I've formatted this date manually into a new column 'Date AU' and used this on the graphs? (Date AU = format('POST DATA'[Date],"dd mmm hh:mm")). When I go to the query editor, this column isn't there as it's not from the original data set.
Is there another way around this? If I pull in the 'date' column onto my graph, it brings up the date heirachy, but this doesn't include 'time', which i need for the graph.
Hopefully this all makes sense, thank you for your help!
Sonia
