topic Hide/show columns for hierarchy tables in Developer

Hide/show columns for hierarchy tables

agis07 — Tue, 16 May 2023 13:35:20 GMT

I have a hierarchical table with 2 levels. On the parent level I have 10 relevant columns to show (one row per shipment). On the child level, I have listed the SKUs in each shipment. For the lower level, I have the same 10 columns plus another 3 columns related to the SKU information. Since each shipment could be multi SKU, showing the 3 additional columns would be messy. So I want to hide them and only unhide when the second level is expanded. Is there any options available?

Re: Hide/show columns for hierarchy tables

Mahesh0016 — Sat, 20 May 2023 06:48:48 GMT

@agis07 Please Share your end output and dataset!!THANK YOU!!

Re: Hide/show columns for hierarchy tables

agis07 — Mon, 22 May 2023 08:39:48 GMT

Hello, below is the output file.

The first table is with expanding document number 1013994406. The "display" column is added by power BI. I would like to unhidde (show) the column "product category" when at least one document is expanded. When no documents are expanded, the second table below would be shown.