Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pratk30
Advocate I
Advocate I

Show/Hide Column in Power Bi

Hi Folks,

 

Is there any idea in power bi show/hide column based on some criteria.

 

In SSRS it is possible using Column Visibility functinality which allows to hide or show column dynamically based on parameter value.

 

 

Regards,

Prateek Mangal

3 REPLIES 3
Anonymous
Not applicable

The solution we use is to create 2 tables, one with the column(s) and one without.

Then create a Bookmark for each state, ie one shows the table with all the columns and hides the limited table, then reverse for the other bookmark.

Place the two tables on top of each other and use a slicer / button etc to switch between the bookmark views.

To ensure filters are retained when changing between bookmarks, right click both bookmarks and deselect data.

v-ljerr-msft
Employee
Employee

Hi @pratk30,

 

Here is a similar idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. Smiley Happy

 

Regards

Show/hide is currently static and universal. You cannot apply criteria.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.