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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mja15
New Member

Power BI Issue: Persistent Table Headers with Slicer Selection

Hello!

I'm new to Power BI and am still learning the basics. Currently, I'm facing an issue related to table visibility based on slicer selections. I've used the measure:

SlicerSelection = SELECTEDVALUE('Activity'[Activity1], "None")

I then set this measure as a filter for the table. It works as expected: when I select an option from the slicer, the corresponding table displays. However, when I choose a different option in the slicer, the headers from the previously displayed table remain visible. Is there a way to hide these headers when a relevant table option isn't selected?

4 REPLIES 4
ray_aramburo
Super User
Super User

Try using field parameters. For a detailed explanation check this documentation.





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Thank you! However, I have another concern. I want to display an entire table that has around 15 columns. Is it possible to set just the table name as a parameter, rather than specifying individual columns?

Not to my knowledge. Field parameters only work with columns.





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Thank you for the reply!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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