My visual returns the correct values when a slicer selection is made. However, the visual errors out when no selection is made.
What can I do to have a default value selected if the slicer is cleared? Thanks for your help.
Regards,
Rupert
My visual returns the correct values when a slicer selection is made. However, the visual errors out when no selection is made.
What can I do to have a default value selected if the slicer is cleared? Thanks for your help.
Regards,
Rupert
Yes, see here as well
But you can also use SELECTEDVALUE function, which is probably the best option actually these days.
Thanks
Sam
Thank you for your quick response. This solution works and I truly appreciate your help.
Thanks, Sam. I tried your solution and it works for me also. I now have two solutions to my problem. have a great day.