Execute settings on Report opening

[Vimalaanand]

Hi, 

I would prefer to execute a code or Dax to set slicers based on the person launching the report. 

So can you let me know if there is an option to execute any code on report opening?

Thanks 

[mihart · Accepted solution]

Hi @Vimalaanand 

You could try using paginated report.  Prompt for username and then when report opens you can have slicers based on the person authenticated. 

"Add interactive features such as document maps, show/hide buttons, and drillthrough links to subreports and drillthrough reports. Use parameters and filters to filter data for customized views."

Here's a good article to get you started:  https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-...

HTH,

Michele

[v-xuding-msft]

Hi @Vimalaanand ,

What the results do you want? If you are trying to show the values of date while opening, you could use the relative date filter to filter slicer or use a relative date slicer directly. For more details, please take a good look at the document:

Creating a relative date slicer and filter in Power BI  

If you want to show other values, you could try to create a measure to show them. For slicers, there is not a option to set them show while opening.

If there can't work for you, please share a few screenshots to let us understand clearly.