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