Forum Discussion
Execute settings on Report opening
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
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-bi
HTH,
Michele
2 Replies
v-xuding-msftCommunity Support
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.
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-bi
HTH,
Michele