Forum Discussion
Hide (blank) row headings/subtotals in pivot tables
Hi Team, I am looking for a solution to blank heading/subtotal rows in a pivot table with a multi level hierarchy. A label filter is an easy enough solution providing the (blank) label value is a...
Alistair Wallace , SergeiBaklan OK, thank you both for your replies. This must be a fairly common scenario/problem, so I'm amazed Microsoft haven't designed a solution to address this issue - it seems like a fairly simple and basic requirement. Still, if that's the way it is then I guess I, too, will have to live with the blanks.
Many thanks.
Requirement could be simple but solution is quite complex. To exclude from hierarchy levels with empty string in name is the same as to exclude level with any other text as name.
Actually you need to rebuild hierarchy on the fly moving next levels upper if current level has empty string in name. Perhaps there are DAX samples, not sure.
- @SergeiBaklan
I've been mulling my problem over and experimenting with my dataset since my last post and arrived (independently) at the same conclusion. In fact, I managed to do what I needed (I think - I'm still experimenting somewhat!) relatively simply using M code inside the power query which originally did the ETL on my data.Would you please describe your solution?
