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
Hi Anonymous
I made a test with a simple SUM calculation for three hierarchy-level rows. The decending sorting seems correct. Do you mean the sorting in the child hierarchy doesn't work correctly when the calculation is very very complex?
Best Regards,
Jing