I have a table with a hierarchy, and I need to add a button to expand all levels of the hierarchy, that is, being at the top level of the hierarchy, click the button to view in the table all levels, without drilling down level by level, how can I do it?

Hi @MJ P.​ 

I believe the default hierarchy drills down one level at a time, so to achieve what you are expecting we can make use of Sets or Parameter dashboard actions.

I my example I have used a Parameter action to drill down to the lowest level of the hierarchy. Check if this solution helps in your case.

⌗Step1 - Place all the fields which forms an hierarchy in Rows shelf (I have used Product hierarchy from Sample SuperStore data)

#Step 2 - Create a Parameter - e.g. p_Category, which have values from your Top level field of the hierarchy and add an extra value say "+"

#Step 3 - Create calculated fields for all the other levels of the hierarchy using below logic

IF [Category]=[p_Category] THEN 
    [Sub-Category] 
ELSE 
    '+' 
END
 
//Manufacturers
IF [Category] = [p_Category] THEN 
    [Manufacturer] 
ELSE 
    ''  // you can use a + sign as well, however I used a blank for asthetics purpose
END
 
//Product_Name
IF [Category]=[p_Category] THEN 
    [Product Name] 
ELSE 
    '' 
END

#Step 4 - Place the sheet in the dashboard to setup the Dashboard Parameter action

Once set you can then drill down to the lowest level from the topmost level.

Attached is the workbook.

Let us know if this help resolves your query, by marking the answer as "Best" , which will close the thread and make the solution easier for others to find. 

Thanks!!