Forum Discussion

MaxNovak's avatar
MaxNovak
Icon for Resolver I rankResolver I
6 years ago

How to get Cascading Sort in Power BI Pivot for every column

Hello,

I am trying to get Cascading Sort in Power BI Pivot for every column like in this photo. Is this kind of sort only possible in excel?
Every suggestion is welcome. 

Show and Tell
Tips and Tricks

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi MaxNovak 

    As tested, we could only sort the matrix by columns in "row" (column "customer") or in "value" field (column "value").

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.