Forum Discussion

sprasad's avatar
sprasad
Helper II
7 years ago

Sort By in the Visual

In the graphic visual I want to do a "Sort By" 2 items? Is it possible? Right now I can sort by only one item .
Need Help
PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

sprasad  Try creating a unique key field as a supporting field for sorting, for each combination of fields that you want to sort on. Then, use that new field as your sorting column.

sprasad's avatar
sprasad
Helper II
7 years ago

Explain a bit on how do it?

Take this example

DatabaseOperating SystemBrowser
Oracle 11gWindows 10Chrome
SQL Server 2016Windows Server 2012Chrome
SQL Server 2016Windows 10Chrome
SQL Server 2016Windows 10Safari
SQL Server 2014Windows 10IE
Oracle 12cWindows 10Chrome
PostgresWindows 10IE
SQL Server 2016Windows 10Chrome
SQL Server 2016Windows 10Chrome
SQL Server 2016Windows Server 2016Chrome
SQL Server 2016Windows 10Safari
SQL Server 2016Windows 10Chrome
SQL Server 2016Windows 10Chrome
SQL Server 2016Windows 10Chrome
SQL Server 2016Windows 10Chrome
  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi sprasad 

    In this example, do you want the "Database" sorted by "Operating System" and "Browser" as below?

     

    Which visual do you need to sort as your said?

    Which columns do you add in the visual? one column or serveral columns?

     

    Best Regards

    Maggie

    • sprasad's avatar
      sprasad
      Helper II
      7 years ago

      Maggie,

       

      I need to all all the 3 coulumns in the visual and I should do the sorting of Database and Operating system.

      Thanks

      Sudhir

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi sprasad 

        one workaround is create a calcuated column

        Column = [Database]&[Operating System]

        add this column in the table

        click on the column header to select "desc"/"asc".

        If you want sort by first column ASC and sort by second column DESC.

        you could create rank measures to sort by.

        for example.

        create measures, then click on "rank3" measure header to sort

        Measure1 = MAX(Table1[Database])

Measure2 = MAX(Table1[Operating System])

Rank1 = RANKX(ALL(Table1),[Measure1],,ASC,Dense)

Rank2 = RANKX(ALL(Table1),[Measure2],,DESC,Dense)

Rank3 = [Rank1]&[Rank2]

         

        Best Regards

        Maggie