Forum Discussion
BeckyXie
5 months agoNew Member
Matrix Columns Sorting by DAX Measure Value - Need Dynamic Column Order Based on Measure
Hi Team, I need to sort Matrix columns dynamically based on a measure value (Sales), and have this sorting respond to other filters (Product). The columns are "Factory" fields, and I need them orde...
- 5 months ago
You might be able to do that with Deneb but it requires custom coding. A workaround is to rank the column header by the sales value and materialize the sales value in a table that holds the rank numbers. Use the rank as the first level in the hiearchy. It is a bit tricky to setup as well.
BeckyXie
5 months agoNew Member
FBergamaschi Thanks for your quick reply. Do you have any ideas which custom visual support this requirement?