create Expand Collapse(+) in a single column

[ak77]

Hi Gurus,

need a help on the below scenario. Please check

i have the below dashboard.. where for the below title column i need a expand collapse feature.(+) based on the level code for a particular sequence group fir Title column

Example: for Sequence .000.000.001.000.000 Level 1 ( FIXED INCOME LONG BONDS) should have (+)  and on expand of it, level 2 ( CLGP) should be displayed and on expand of Level 2 ,all level 3 should be displayed ( BASIS, CLOS, Cash & Equivalents, etc) and so on

 Please help if this is possible ? 

[ryan_mayu · Accepted solution]

have you tried matrix visual and set up the stepped layout.

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual?wt.mc_id=DP-MVP-5004616

[Anonymous · Accepted solution]

Hi @ak77 

Power bi doesn't support to create expand collapse in single column in table visual currently.

Just as @ryan_mayu said that you can consider trying the stepped layout by creating a matrix visual.

Or maybe you can try to use the drill up/down.

Here for your reference:

Drill mode in the Power BI service - Power BI | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu · Accepted solution]

have you tried matrix visual and set up the stepped layout.

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual?wt.mc_id=DP-MVP-5004616