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
Highlighted
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

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.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 311 members 3,048 guests
Please welcome our newest community members: