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.
Hi
I want to display months in columns but its showing me in alphabatically sort order. I want to show in month wise sort order.
If anyone know please let me know how to do this. Note*: I am using direct query.
Thanks in advance.
Worked flawlessly, thanks.
This is how far I got in getting the months in order using chilcleslicer, based on the fact that I am facing the same issue.
I got the number to show in order from right to left but its braking in sep putting dec in the place of oct.
I've never worked with direct query, but, are you able to use a "first day of month" column instead?
This will be of a date type, sorted correctly. And you can probably format it to show month and year.
@zivhimmel I have a date column , month number column and month name calculated column.
Does your data have a column showing the month by number? May help if you can screen capture the columns of your data (non-sensitive data if possible).
Yes, I have number column as well.
but when i am using month name , I am not able to do monthwise sorting..
If you select the Month Name in your field list pane, then under the Modeling tab select 'Sort by Column'. You can chose to sort the name, by your month number field. This should still work in Direct Query mode.
Sure it is. I'm using the June version of the Power BI Desktp. It's available from the Modeling tab of the desktop (not in power Query editor). You have to select the field from the pane on the right, then the ribbon option becomes available.
@steph_io But in direct query "Sort by column" is disabled. Please refer the below screenshot.
Thanks.
I'm having the same issue, using a cube as my source. Is there a solution for this problem?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |