Expand and Collapse (In SSRS It is called Toggle) for a column in Table

[Anonymous]

Hi All,

I have a requirirment where I have to expand and collapse a column details in Power BI Table. 

Actaully, I am working on a report to find out all the running session on a SQL DB. This Query has SQL Text which can be too long and I want this column to be collapsed initailly and if some body wnats to Expand can expand and see what query is running. 

Anybody has done similar thing please post steps. 

[Anonymous · Accepted solution]

I Have achieved this using Bookmark and Seleclection pane features.

So Created 2 Tables in Visual Pane:

Table-1: has 7 columns 

Table-2: has 8 columns

Added 2 buttons: 1-Forward Button and 2-Backward Button.

Created a bookmark called "WithoutQuery" and in Selection Pane hided Table-2 and Backward Button

Created a bookmark called "WithQuery" and in Selection Pane hided Table-1 and Forward Button

Then Selected the Forward button and clicked on Action=On-->Type=Bookmark-->Bookmark=WithQuery

Then Selected the Backward button and clicked on Action=On-->Type=Bookmark-->Bookmark=WithoutQuery

[Greg_Deckler]

Use a Matrix visualization, it supports collapsing and expanding.