Forum Discussion
Sorting Complex Matrix visual by Column subtotals
Dear Experts, I am facing specific problem.. I have found out that Power BI has the problem to sort matrix table based on column Subtotal when My matrix table is quiet complex.. It contains 3 lvl hi...
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
I 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