Forum Discussion
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 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 |
2 Replies
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/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.
