Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom sort order in two charts

Hi,   I have a request to custom sort two charts based on the same table but different columns. I know that I can create sorting order column for one chart but I am not sure how can I do that for a...
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    Anonymous  In Power Query, add new Conditional Column to the table in your screenshot: 

     

    If  Priority equals Low then 1

    add condition

    If Priority equals Medium then 2

    add condition

    If Priority equals High then 3

    else 4

    Name this column [PrioritySort]

     

    Then repeat with a new conditional column for [Time Left Sort]

    And then you can use the 'Sort by Column' functionality to sort Priority by [PrioritySort] and Time Left by [TimeLeftSort] . 

    https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column