The method for hiding items with zero totals in a PivotTable is different if you're working with a regular PivotTable or a PowerPivot PivotTable. This article focusses on how to accomplish this goal in the PowerPivot version. (If you're working with a regular and you want to hide calculated items that have zero balances, you'll want to check out
Debra Dalgleish's blog post on the subject.)
To start, assume that we’ve got a fairly simple PowerPivot pivot table that looks like this:
...
Knowledge Base Articles By Category
Recent Forum Posts
Power Query to move 24 values
let Source = Excel.CurrentWorkbook(){[Name="Tabela1"]}[Content], ColD = List.Combine(List.Transform(List.FirstN(Source[D],