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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Hide/Show slicer based on text search slicer

I'm working on a project that displays student dashboards at the moment. I want to include a slicer in the dashboard, but I don't want the students to be able to see it. Only the tutor, who has entered his or her password in the text search slicer, will be able to see the slicer with the names of their students in it. I have an excel file containing each student's name, role (tutor/student), and password for that purpose. Neither do I want RLS to be performed nor do I want the password to be hardcoded inside the measure. I want DAX metrics to be used for this. Additionally, there will be various student names for different tutors because I am doing this for multiple classes. I want the tutors to be limited to knowing the names of their students and nothing else.

2 REPLIES 2
mlsx4
Memorable Member
Memorable Member

Hi! 

 

Take a look at this post: https://databear.com/hide-show-items-in-power-bi/ 

It may help you.

Anonymous
Not applicable

hi the thing i wanted was the text search to be connected to the slicer where the slicer will only pop up after the password is typed in the filter but this one really doesnt show anything other than the connection between two slicers

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors