Skip to main content

Power BI

New

Decomposition Sort Order

Vote (30) Share
Peter Ivers's profile image

Peter Ivers on 15 Nov 2019 00:15:52

The new Decomposition Visual is great, but it assumes you always want to sort high to low on the metric value. That doesn't work if you add a time field like Month, where you want to show the data over a year, you want by category order. Also some metrics have meaning where lower is best, for example defect rates, so you need full control over the sorting at each decomposition level. The developer should be able to predefine the default sort per level, but allow the end user to change.