Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have checked whole tutorial but I have no idea How to implemet it in my case

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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