Skip to main content
Microsoft Idea

Power BI

Needs Votes

Sort values in Column Profile Value Distribution

Vote (1) Share
Peter Ivers's profile image

Peter Ivers on 25 Jun 2020 22:24:11

This feature is useful showing value distributions. It seems to recognize dates, allowing grouping by month, day, however when you display by value it sorts by the highest to lowest number of days leading to seemingly random date order on the axis. Because of that you cannot clearly see when you are getting more values at a time of year for example. When you group by month, multiple years are grouped together, you need group by Year/Month. Also a you might want to display category labels in alphabetic order. So the idea is to have a Sort By including the value and value label ascending/descending in addition to grouping, with smart ordering of dates (value rather than label).