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 ...
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.
