Forum Discussion

slohombre's avatar
slohombre
Brass Contributor
Oct 09, 2020
Solved

How to filter out data in a power pivot table without values?

Hi, all. I'd like to filter out data in a power pivot table that does not have values. In the attached picture, any rows that do not have dollars in the sum of amount" column I want removed. What's t...
excel
  • onethreeone's avatar
    onethreeone
    Oct 09, 2020

    Hi Paul slohombre 

     

    If you right click on one of the Row Labels in your left-hand column and then go to Filter and Value Filters Choose Sum Of Amount Does not equal 0

    That should sort it for you.

     

    Good luck!

Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Oct 09, 2020

slohombre 

You may apply a "Does Not Equal" 0 "Values Filters" on Row Labels to hide the Row Labels where Sum of amount is 0.

 

 

 

Resources