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.
- Comments (3)
RE: Decomposition Sort Order
If we could choose the sorting order it would make this visual more valuable. At the end each visual has an objective and might not be always by higher value.
RE: Decomposition Sort Order
"It would be so much easier if there were a sort icon to let the end user quickly sort each tree hierarchy level values either in ascending or descending order." ---- totally agreed!
RE: Decomposition Sort Order
Possibility to choose min or max sorting of the decomposition tree values would be truly helpful!
My customer is really impressed with this visual and want to see a _ready-made_ visualization based on a fixed hierarchy and for certain pre-defined calculations. The less clicking they have to do, the happier they are. :)
In the visual, I have a value to be calculated and three levels on the tree. (Say: ProductGroup, ProductType and SerialNumber - in that order.)
My customer wants to see three analysis options for the values in this visual: STDEV, MIN and MAX.
These options are implemented as Slicer 'buttons' and SWITCH based calculations.
If the user wants to investigate the lowest values in those three levels (by selecting MIN from the slicer), the values in the visual are by default sorted from high to low. Not from low to high.
There is the arrow to help to browse the tree items but my customer can have hundreds of SerialNumbers per one ProductType, for example, so scrolling down to the lowest value (worst SerialNumber) takes ages and is not user friendly.
It would be so much easier if there were a sort icon to let the end user quickly sort each tree hierarchy level values either in ascending or descending order.
Thank you!
PS: I have examined the AI features ('Low value'), too, but there are features/things in that solution that prevent me from using them in this use case.
PPS: If this cannot be implemented quickly (for my current client), hopefully the future Power BI users will still have this functionality at some point. =)