Default Value for a Slicer

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.



Check out the video below, which walks through this issue in detail:

  • Brian

Yes, see here as well

But you can also use SELECTEDVALUE function, which is probably the best option actually these days.


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.