How to set slicer value to the first available value from a table in Power BI?

[Anonymous]

I have a requirement that the selected value in slicer must be valid.

Let us suppose if I select a value in Store slicer and that store gets deleted from the company. The slicer will still show its name with no data in visuals interacting with the slicer.

Default Value Selected

Updated Slicer Value Manually

 But I want only the relevant store selected in my Store slicer. I know its slicer's property to retain the value which is set in it while publishing the report, but is there any workaround for it.

[v-kelly-msft]

Hi @Anonymous ，

Based on my research, it is not supported yet currently. You can come up with a new idea and add your comments there to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!