Martijn1 on 1/13/2018 9:38:32 PM
Power BI
Add sorting options to visualisation pane (for all visuals)
I wonder why sorting has so limited options for most visuals. We have advanced filter options, but sorting is also a very powerful element in visuals. In most cases, it is only possible to sort on the fields that are in the visual and you can choose only one of them. Why isn't there a way to add more sorting fields (in hierarchy), just like in excel? Why isn't it possible to sort on a field that isn't in the visual? I know that it is possible to sort a field by another field, but that is no solution if I want to use that field in another visual without that specific sorting. My simple solution: add sorting options to the visualisation pane, just as values, axis, filters, etc.. So it's easy for users to choose the sorting fields they want and in which order (if multiple).
Lukas Long on 10/14/2022 11:14:44 AM
Power BI
Sorting
Greetings,
It would be really useful in Labor Control and the other areas if we were able to sort multiple times using multiple columns. For instance, first sort would be based on Column 3 and the second sort would be based on Column 6 while maintaining the original sort from Column 3. This would allow us to group general items and then further sort for quick review. I realize you can select specific items and sort just those, but that is not helpful if you wish to print a report (you would have to do that several dozen times to get everything).
Daniel Kiss on 12/7/2020 1:39:51 PM
Power BI
New sorting options
hi MS! If we have two databases with one (or more) connections between eachother in the Model tab, it would be a great feature if if have a visual from database 'A' values that would be really helpful if in the sort by option we could have the connecting values/columns from database 'B' where it is connected thanks in advance! Best!
ammannasm@gmail.com on 9/17/2018 5:20:06 PM
Power BI
sorting
We Should be able to Sort the values with Category / hierarchies, Say Example Sort by number of customers within each State, Region and Branches
Stephane Eyskens on 11/25/2015 6:40:05 PM
Power BI
sort
I might have overlooked it but I didn't find any way to remove sorting. If I connect a report to a VIEW, I'd like the report to respect the SORT I specified for the view.
Alan Edwards on 7/26/2019 6:08:51 PM
Power BI
sorting
Would like the end users to sort on any column when I publish or distribute the report
Ayhan Akgun on 6/14/2016 3:14:04 PM
Power BI
Modeling and Advanced Query options in Microsoft Analysis Services Cubes support
Power BI have modeling and advanced query options for SQL Server datasources, but I can not use similar functionality for MS analysis services cube datasources, Do I miss something or this MDX lecel querying and modeling options are not ready for Power BI desktop yet ? I use, custom column generation and then sort this column using another data column in Power PI modelling feature for SQL server dataset but it is not possible for analysis services cubes datasets. Any comment or workarounds are apprecciated.
rohit Pradhan on 3/28/2023 5:59:46 PM
Power BI
Sorting
- Need to add Column Sorting Features on terms of value and text.
- In Matrix Mode, Colum Subtotal should be automatically same format with rest of the Colum data in Matrix
Milos Acimovic on 10/8/2021 11:59:42 AM
Power BI
Matrix sorting
Allow the matrix to be sorted by values but keep stepped row headers not being sorted. For example when you create matrix with product categories and years in the rows. If you sort the whole matrix by sales value years also get sorted which in some cases can cause inconsistency.
Power BI Ideas Admin on 11/8/2016 12:04:16 AM
Power BI
Improve sorting
Improve sorting options, maybe also a panel for a custom sorting in each visual object (kind of sorting designer)