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 All,
I am facing sorting issue while using the year & cycle concatenation column in silcer. It is not sorting as expected .
Acutal Result:
Expected Result:
2019-September Preliminaries
2019-December Preliminaries
2019-Year End
2020-September Preliminaries
2020-December Preliminaries
2020-Year End
Solved! Go to Solution.
The Concatenation Column is of Text type so it's sorted by text alphabetically by default. You need to add a new column e.g. YearMonth column which has values like 201909, 201912, 201913 (for year end) and change this YearMonth column to Number type. Then sort Concatenation Column by this YearMonth column.
See: Sort one column by another column in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
The Concatenation Column is of Text type so it's sorted by text alphabetically by default. You need to add a new column e.g. YearMonth column which has values like 201909, 201912, 201913 (for year end) and change this YearMonth column to Number type. Then sort Concatenation Column by this YearMonth column.
See: Sort one column by another column in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |