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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
harshadrokade
Post Partisan
Post Partisan

Error message while invalid value selected in slicer

I have two slicers coming from single table. The slicers are kept with option as sinngle select only.

 

Slicer 1- Student name

Slicer 2- Date

 

When I select a value in Student name slicer, the Date slicer is auto filtered. But as I have disabled the interaction on Student name slicer based on Date slicer, the values in Student name slicer doesnt impact even if I slect any date in Date slicer.

 

If I select value as 'St1' in Student name slicer, I can see values in Date slicer as '23-12-22, '24-12-22' & '25-12-22'. Then If I select value as '24-12-22' in Date slicer, I can see data related to 'St1' & '24-12-22' on dashboard.

 

If I select value as 'St2' in Student name slicer, all the visuals on dashboard go blank as 'St2' dont have date as '24-12-22' (refer below table). The visuals appear again when user selects new value in Date slicer as '26-12-22' or '27-12-22' or '28-12-22'

 

I want to show a text message as 'Select valid date' on screen whenever user tries to select a new student name in Student name slicer & if the date already selected in Date sclicer is not applicable to that Student name. 

 

 

Student nameDate
St123-12-22
St124-12-22
St125-12-22
St226-12-22
St227-12-22
St228-12-22
St329-12-22
St330-12-22
St331-12-22
St301-01-23
2 REPLIES 2
amitchandak
Super User
Super User

@harshadrokade , Create a shape(rectangle with message) . Your visual background should be 100% transparent,

 

put the shape behind that.

And for text color of shape use measure like , assume you have count measure

 

if(isblank([measure]) , "#000000", "#FFFFFF00")

 


Show hide page
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks @amitchandak 

 

O cant use my existing measure (Like count) here as the same can be genuinely blank & if thats the case, the text on the shape will be wrongly shown on dashboard. I want to show the said message on dashboard only when the combination of Student name & date doesnt exist.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!