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.
i'm just trying out some simple visual with some recent data
I have data for Nov 2017, Dec 2017 & Jan2018
but when it display in chart, the sorting is messed up ( on the axis, i have removed the year & quarter levels) so it shows the data by month, but sorting is messed as it took Jan data 1st
Solved! Go to Solution.
Dear d1x0nl30ng,
You should use another column with Number, it's the best way for sorting Date.
Right click on your Table, choose "New column", type a name, ex "Month Key" = FORMAT ( YourColumnDate, "YYYYMM" )
Then sort by Month Key.
Regards,
ManNVSM.
Dear d1x0nl30ng,
Please try Sort By.
Go to Data > Modeling > choose your column, click "Sort by" and choose another data can sort Acs, Des.
For exam: i have a column WEEK, it's sort by ABC, i will change it Sort by "Number of Week".
Regards,
ManNVSM.
see below screenshot, i need to group my data by months, there isnt any other meaningful column i can sort with existing data.
Do i need to create another column (i.e. for nov2017 - 1, dec2017 - 2, jan2018 -3 , then sort ascending 1,2,3 ) ??
Dear d1x0nl30ng,
You should use another column with Number, it's the best way for sorting Date.
Right click on your Table, choose "New column", type a name, ex "Month Key" = FORMAT ( YourColumnDate, "YYYYMM" )
Then sort by Month Key.
Regards,
ManNVSM.
Thanks
Nice to help you 🙂
Hi @d1x0nl30ng
What you would need to do, is to put in a sort by column, which will then enable you to sort your dates correctly.
The best practise would be to actually create a date table and then leverage the dates in the date table. This would then also allow you to leverage all the DAX time intelligence functions.
Here is an example on how to achieve this: https://www.fourmoo.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fi...
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 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |