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.
Hello All,
Kindly help me on below issue.
I want to sort this measure by ASC or DESC order but the problem is that measure having text datatype because of decimal formatting.
How can we solve this problem?
LY Actual Value_L3 = var _format= CALCULATE([Actual Value],FILTER('Master Calendar','Master Calendar'[IS Last Fiscal Year]="Yes"))+0 return FORMAT(_format, SWITCH( SELECTEDVALUE('Number Format'[Decimal Place],"#,#0.00"), 0,"#,#0", 1,"#,#0.0", 2,"#,#0.00", 3,"#,#0.000" ) )
Hey @HarshuGangurde ,
You can try and sort it by another column which is Number by using Sort by Column.
To do this select your measure in the fields list and then on the Modeling Tab select Sort by Column and select the Number Field.
Hi,
Would you please share a sample data,
I created the sample data for my self, and it is worked :
Hello,
Could you please share your sample data.
Thanks.
I put as a screen shot in my previous post
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |