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

Dashboard showing data when none is selected.

Greetings everyone.
 

I need help on this. As you guys can see below, I selected no students from the slicer. But the visual is still showing me the data. I need it to be blank (shows no data at all). How do I fix this?

 

Jane_D_0-1698989580774.png

 

Thanks! Your help is greatly appreciated! 

Ps: I am new to Power BI so you guys will see me around more often! Thank you again and have a great day!

 

1 ACCEPTED SOLUTION
Jane_D
Regular Visitor

Has been solved ✔️

View solution in original post

5 REPLIES 5
Jane_D
Regular Visitor

Has been solved ✔️

Arpitb12
Helper I
Helper I

SelectedStudent = IF ( ISFILTERED(add the column name you are using as slicer), CALCULATE([YourCalculation], YourFilterContext), BLANK() )

try this replace properly the values

But theres no calculation for the visual. Like the student name, even when I selected no student, it still showed me 'Adam' there. I use a card visual for it so theres no calculation. 

Kishore_KVN
Super User
Super User

Hello @Jane_D , 
While creating the values for that calculation, use SELECTEDVALUE DAX function and make blank if nothing is selected. 
For example you can write your calculation as below:
IF(SELECTEDVALUE('Table'[Studen]) = BLANK(), BLANK(), Your_Calculation)

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

But theres no calculation for the visuals. Like the student name, even when I selected no student, it still showed me 'Adam' there. I use a card visual for it so theres no calculation. 

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