I have a pivot table that needs to be sorted a particular way: Priority 1: non-zero values on top and zero values on bottom, according to column B Priority 2: numerical order (least to greatest), according to column A This needs to be maintained automatically as I refresh data under the Data tab Any help on this would be appreciated, I'm new to Power BI and pivot tables. Thanks a ton!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Sorting my Pivot Table

I have a pivot table that needs to be sorted a particular way:

Priority 1: non-zero values on top and zero values on bottom, according to column B
Priority 2: numerical order (least to greatest), according to column A
This needs to be maintained automatically as I refresh data under the Data tab

Any help on this would be appreciated, I'm new to Power BI and pivot tables. Thanks a ton!