Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: PowerPivot Sort Multiple Columns

  1. #1
    Board Regular
    Join Date
    Apr 2008
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default PowerPivot Sort Multiple Columns

    PowerPivot Sort Multiple Columns

    Apologies if it is a stupid question, is there a way to sort two columns in PowerPivot ?

    For example, sort column 1 by High-Low, and then still preserving that sort, move to column 2 and sort that ?

    Column 1 could be customer number, and then column 2 Date, so all customer orders together and then in date order.

    As soon as I highlight two columns the Sort button disappears, and I want to add a formula to look at the time between orders, but obviously that relies on all customers being together and in date order.

    Thanks for your help

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Sydney, Australia
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default Re: PowerPivot Sort Multiple Columns

    Are you talking about the power pivot window? If so, no. Power pivot is a database, not a spreadsheet - the order of the data in storage is not trackable or referanceable.
    Matt Allington is a professional Power BI consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia at
    Author of the books Supercharge Power BI and Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts