cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ffitzpatrick47 Regular Visitor
Regular Visitor

Sorting on non display columns in power pivot and filtering on measures

image.png

I want to filter on measures.  The way I have been doing it is with a new measure that looks like:

new measure = if(oldmeasure condition,oldmeasure,blank()).  But surely, this is not how powerpivot was intended as normal people shoudl be able to do this easily without cracking out the Dax Patterns book.

 

Then, I want to sort on difference for ordering, but not actually show that column.  Aside from hiding the column in excel (which is the cowards way), is there some other way to sort by that column without actually displaying it?

4 REPLIES 4
Ffitzpatrick47 Regular Visitor
Regular Visitor

Re: Sorting on non display columns in power pivot and filtering on measures

I think I figured the filtering out.  You have to right click a row, not a column on the value of which you want to filter.  I forgot the interface is counterintuitive

Moderator v-yuezhe-msft
Moderator

Re: Sorting on non display columns in power pivot and filtering on measures

@Ffitzpatrick47,

Please check if "sort by column" feature works in your scenario.

Also, about Powerpivot issues, you can post question in PowerPivot forum to get dedicated support.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ffitzpatrick47 Regular Visitor
Regular Visitor

Re: Sorting on non display columns in power pivot and filtering on measures

Sort by column works, the issue is sorting over a column that doesn't exist, I haven't solved that

Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Sorting on non display columns in power pivot and filtering on measures

@Ffitzpatrick47,

Please post question in PowerPivot forum to get dedicated support.


Regards,
Lydia

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