Error message while invalid value selected in slicer

[harshadrokade]

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 name	Date
St1	23-12-22
St1	24-12-22
St1	25-12-22
St2	26-12-22
St2	27-12-22
St2	28-12-22
St3	29-12-22
St3	30-12-22
St3	31-12-22
St3	01-01-23

[amitchandak]

@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/

[harshadrokade]

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.