Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Ffitzpatrick47
Helper II
Helper II

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
v-yuezhe-msft
Employee
Employee

@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.

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

@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.
Ffitzpatrick47
Helper II
Helper II

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.