Forum Discussion
Sort with DAX Function FORMAT
Hi Anonymous,
I'd like to suggest you create a calculated column and setting 'sort by column' property to use the original numeric field as sort order, it can fix the 'sorting issue' text value sorting order.
In addition, you can also try to use the table properties formatting feature to change your measure format instead of use format function, this feature does not change the type of formula result.
Regards,
Xiaoxin Sheng
Anonymous wrote:
Hi Anonymous,
I'd like to suggest you create a calculated column and setting 'sort by column' property to use the original numeric field as sort order, it can fix the 'sorting issue' text value sorting order.
In addition, you can also try to use the table properties formatting feature to change your measure format instead of use format function, this feature does not change the type of formula result.
Anonymous If you read the response from Anonymous just above your reply you will see that neither of these options will work. Roberto456 is trying to dynamically change the formatting based on the filter context so neither a calc column or the measure properties will work for this. Unfortunately there is no good solution for this at the moment other than maybe changing the structure of the report to see if you can make use of separate measures instead of doing a switch on the KPI id.
HI d_gosbell,
Thanks for your remind. (after doing some further test with measures and 'properties formatting' feature, it seems the same as you mentioned)
Anonymous Current power bi seems not able to achieve your requirement, perhaps you can submit an idea for your requirement to the ideas forum.
Regards,
Xiaoxin Sheng