Skip to main content
Search

    Search Microsoft Fabric Ideas

    Vote 10
    Martijn1 profile image

    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).

    Needs Votes
    Vote 6
    Lukas Long profile image

    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).

    New
    Vote 1
    Daniel Kiss profile image

    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!

    Needs Votes
    Vote 11
    ammannasm@gmail.com profile image

    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

    Needs Votes
    Vote 8
    Stephane Eyskens profile image

    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.

    Needs Votes
    Vote 1
    Alan Edwards profile image

    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

    Needs Votes
    Vote 7
    Ayhan Akgun profile image

    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.

    Needs Votes
    Vote 2
    rohit Pradhan profile image

    rohit Pradhan on 3/28/2023 5:59:46 PM

    Power BI

    Sorting

    1. Need to add Column Sorting Features on terms of value and text.
    2. In Matrix Mode, Colum Subtotal should be automatically same format with rest of the Colum data in Matrix
    New
    Vote 12
    Milos Acimovic profile image

    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.

    New
    Vote 118
    Power BI Ideas Admin profile image

    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)

    Needs Votes