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
SEC
Regular Visitor

Show/hide Column or Table Automatically based on Slicer Selection

Hello! 

I am looking for a way for Power BI to automatically show or hide a table (or certain columns within a table, if that's easier) based on a selection in a slicer. I have a list of inquiry topics, and I want the table(s) to show the contact info for each topic. There are 2 options for how to contact someone about the topics - either Salesforce or email (never both). So what I currently have is something like this, with blank fields throughout the table:

 

TopicSalesforce ContactEmail Contact
Topc ASalesforce contact A 
Topc B Email contact B
Topc C Email contact C
Topc DSalesforce contact D 

 

I would like to get rid of the blanks because I think it is confusing for users. And I want a solution that does this automatically - not a button the user would select to toggle between Salesforce and Email options. I don't think I can merge the 2 columns into 1.

 

So for example, if the user selects Topic A, the table displays only Salesforce contact A - the Email contact column is hidden. Or perhaps I need 2 separate tables instead of columns, and 1 of the tables gets hidden based on the topic selection. I can make both options work visually.

 

Any advice you have is much appreciated. Thank you!

 

1 REPLY 1
amitchandak
Super User
Super User

@SEC , if those can act as measures then you can try

Learn Power BI: Changing measures based on the axis with Field Parameters in Power BI. Dynamic measures based on the axis/Dimension: https://youtu.be/7ikRAelDph0

 

else you need to use bookmarks

Bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

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.