You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Just starting to learn Power BI and almost immediately I've come across a a stupid problem where it organises a month/year axis alphabetically on a line chart. (Apr, Aug, Dec etc.) This is because its tagged as a text column in my date table, but it won't let me change to a date column format because it won't accept Jan 21 is a date. 😕
I can't be the first! So far Dr Google hasn't helped. Any clues?
Good timing.
A work colleague is an absolute expert here. Unfortunately, he left the business 25 minutes ago so I can't ask him.
Left, as in went home for the evening, or left? Strikes me that might have been really bad timing! 😁
Does this help?
https://www.sqlshack.com/how-to-sort-months-chronologically-in-power-bi/
I have a love/hate relationship with Power BI but most often the issues stem from the structure of your data model get that right and it pays off, get it wrong and you're in for the hell of obscure DAX expressions.
You need to go back to the query editor and get that field to be a date.
Was nervous opening thread.
Obviously did so I appear to be Power BI curious. Never heard of this. Off to google...
That looks like it may well help, thanks. I'll spend some time to work through it properly later.
I'm already finding that about the data structure. One of my colleagues gave me one of his dashboards to give me some ideas and a headstart, trying to follow his data is a flipping nightmare and I'm sure a lot of it is unused.
I thought you were going to be discussing Sorting on a line graph on a speed / power date sort of thing with someone who was Bisexual.
Easy mistake to make. Sorry, in this case I have nothing to add
Normal approach is through the model, set it to a date type there, or, not 100% sure but can you create an index field to sort by and use the text as a label.
I need to get into this, it's in my objectives to have a monthly reliability/asset availability presentation using power BI.
I'm not even particularly good at excel, gonna be fun. 🙈
If only your work colleague had been on STW for years Cougar!
As mentioned above, PowerBI will only sort it in date order if you can get it to recognise the field as a date - but luckily it’s pretty flexible in doing this. You’ve given the example of ‘Jan 21’ as what you have in text format, is all your data in this format?
RM.
If only your work colleague had been on STW for years Cougar!
I knew that! I just couldn't remember the goddamn username.