I am using a single-select slicer on a report that is saved to the report server.

[susanaubuchon]

I am using a single-select slicer to select a customer on a report that is saved to the report server. The customer that is selected when the report is saved stays selected when saved to the server. I have a scheduled refresh that I run to pick up new data and when it runs that customer is no longer in the underlying data. The customer is still showing up in the slicer as selected. Until the user selects a different customer the customer exists in the slicer. When a new selection is made the customer is no longer visible in the slicer.  how do you make it so it selects a new customer on refresh?

[Anonymous]

@susanaubuchon  Hi there,

you need to create a dynamic measure and replace the slicer value with the dynamic measure.

with this, everytime when a new selection is available, it will reflect in the slicer itself.

Regards,
John Basha Mattipati,
https://www.linkedin.com/in/john-basha-mattipati-06812980/

[susanaubuchon]

Thanks for your response. I tried many things the users are willing to live with it the way it is. Not ideal but it works. 

[d_gosbell]

There is no way to do this at the moment. I would love to be able to define the default value for a slicer using an expression (pretty sure I logged this idea on ideas.powerbi.com) but this is not possible at the moment.

You will probably need to change your report design. Could you create a list of employees on one page and then setup a drill through page so that people can drillthrough from that to a page with details about that one employee?