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.
Highlighted
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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 47 members 861 guests
Please welcome our newest community members: