How can we improve Power BI?

Add a multiple columns sort featue

If it is possible please provide the multiple columns sort . For example I want to sort the table visualization based on Priority and severity

959 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    111 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Kelvin commented  ·   ·  Flag as inappropriate

        We are converting reports from SSRS to Power BI. Our client wants the the same functionality, which is to have the reports sorted by multiple columns.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I'd like to sort by year and then by sales/time/counts etc. This is a function that is really needed.

      • Rhonda Smart commented  ·   ·  Flag as inappropriate

        This is basic. BusinessObjects automatically sorts by columns left to right, with options to sort by any column(s) and even custom sorting.

      • Anonymous commented  ·   ·  Flag as inappropriate

        It's kind of silly that this is not already a thing since excel can easily do this. Please allow the option to sort on more than one column in a table or matrix.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We need to sort for example by document number and second sort by doc details line ...

        Multiple columns search is a basic need .

      • Melissa commented  ·   ·  Flag as inappropriate

        This needs to be something that is implemented! Currently working on a report that I need to sort by the year/month and the count of records. A nested sort option would solve this so easily!

      • Ananda Kumar commented  ·   ·  Flag as inappropriate

        The sorting done in Power Query (sorted by multple columns) is not maintained in the visuals. So the whole point of sorting during the ETL is lost when trying to do the visuals.
        As much as the need for multple column sort in visuals it is equally important to maintain the sorting done during ETL using Power Query.

      • Scott L commented  ·   ·  Flag as inappropriate

        Power BI team - there are several requests for sorting on multiple columns. Can you advise if there is any thought being given to these requests?

        The votes are somewhat scattered across multiple ideas, but there is some demand for this feature.

      • Pablo Steyerthal commented  ·   ·  Flag as inappropriate

        The Matrix visual needs ROW and COLUMN SORT by value and mutiple sorting. Not only a multiple sorting for columns

      ← Previous 1 3 4 5 6

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.