Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Use a Matrix visualization, it supports collapsing and expanding.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |