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 have below two columns in my data containing the values - Core, Moderate and Breakaway.
In my Visuals, I want the sort order to be Core->Moderate->Breakaway, but orders as Breakaway->Core->Moderate (alphabetically).
What I have done now is created two conditional columns where I am populating the values 1,2,3 based on the values in the respective columns (below logic). I am then using these index columns to achieve the required sort order.
If(Cluster-2017 = Core, then Cluster2017Index = 1) elseif(Cluster-2017 = Moderate, then Cluster2017Index = 2) elseif(Cluster-2017 = Breakaway, then Cluster2017Index = 3) #Similar approach for Cluster-2016
Is it possible to achieve this using a single column or any other better approach possibe?
Thanks,
Milan
Solved! Go to Solution.
Hi @MilanRao06,
Based on my research, currently, the only way to achieve custom sort is creating extra conditional column, then sort records based on this conditional column. The conditional column is created according to one specific column, it will create a one to one mapping relationship between these two columns in row level. So, it is not available to sort multiple columns which contain exactly same values though based on a single conditional column.
Best regards,
Yuliana Gu
Hi @MilanRao06,
Based on my research, currently, the only way to achieve custom sort is creating extra conditional column, then sort records based on this conditional column. The conditional column is created according to one specific column, it will create a one to one mapping relationship between these two columns in row level. So, it is not available to sort multiple columns which contain exactly same values though based on a single conditional column.
Best regards,
Yuliana Gu
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |