Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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 |
@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.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |