Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a date table that will not sort properly. I have tried the "sort by column" option and have added columns for Sorting Order even though I already had a "Date Offset" column that should have been sufficent. I have search all over and cannot seem to find a solution for this issue. Any ideas?
This is a picture of my date table and how it is showing. When I months from the date table in visuals, they show out of order.
Solved! Go to Solution.
Firstly, the table should be sorted by the date column in ascending order. Then select your "Month Name" column and select "Sort by column" and choose "Month" column.
Proud to be a Super User!
Paul on Linkedin.
Firstly, the table should be sorted by the date column in ascending order. Then select your "Month Name" column and select "Sort by column" and choose "Month" column.
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
76 | |
74 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
48 | |
47 |