Forum Discussion
Sorting Complex Matrix visual by Column subtotals
Anonymous You can try the new dynamic format feature. This is exactly what you need! Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
Here is a blog that may be more helpful than the official document: Introducing dynamic format strings for DAX measures - SQLBI
Best Regards,
Jing
Hello Guys,
Thanks for interacting, unfortunaletly I can not include data set due to confidential data But I have a good news and bad news.. Good neews is that I have found out why it is not sorting.. and It is caused by formating Issue.. My complex measure containing multiple other measures which needs to be formated differently.. Some as Whole numebr, some as Percentage and others as decimal numebrs with 2 decimal precision.. Unfortunately I have used Format fucntion to meet this criteria however as we know format function formt text and thats why unexpected results has occured.. Do you guys have Idea how can I Format measure as whole number, percentage, decimal?
Anonymous You can try the new dynamic format feature. This is exactly what you need! Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
Here is a blog that may be more helpful than the official document: Introducing dynamic format strings for DAX measures - SQLBI
Best Regards,
JingI have checked whole tutorial but I have no idea How to implemet it in my case
I agree this is quite a complex measure...
My idea is that you may try creating a DAX formula similar to your measure. In this formatting DAX formula, where it originally have a calculation formula or a measure, replace it with the format string you want for that calculation. Just like this example
SWITCH ( TRUE (), CurrentValue <= 1E3, "#,0.00 K", CurrentValue <= 1E6, "#,0,.00 K", CurrentValue <= 1E9, "#,0,,.00 M", CurrentValue <= 1E12, "#,0,,,.00 G" )Regards,
Jing