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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

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!