PowerBI Slicer Dynamic Default Value selection based on User Login
How can i configure PowerBI Slicer to Dynamically have Default Selected Values based on User Login. i have a table for users configured with LOB
LOB is assigned to a Slicer in my reports, i want based on user login the LOB Slicer to have default selected values as configured in the table.
example if user2 logins:
if user1 logins:
etc...
your assistance is much appreciated Georges Sabbagh
What you ask is not directly possible in Power BI, but you can achieve something similar using bookmarks. Leave the slicer in the report without any selection, then login as each user (or ask them to do it themselves) and create personal bookmark with the desired items selected for the current user, and make this bookmark to be the default view. Now, whenever the user return to the report, this will override the persistent filter state (specified by you in the report) and land him in the view specified by the bookmark.
- SSRS How to repeat the table header on each page in print preview
- Overlapping Labels in Pie-Chart
- The version of Visual Studio is unable to open .rptproj
- Filter a column with multiple option in a data set
- Can I create a multi-grouped report in SSRS formatted with merged cells?
- Using SSRS, how to retrieve custom start and end dates based on 4-4-5 accounting calendar?
- SSRS 2019 permissions granted to user domain\user are insufficient
- Report with padded zeros cell shows as #VALUE! in Excel
- Multiple Value Parameter Returns One Value Power BI Paginated Report
- The report server can’t connect to its database
- SSRS won't expand the row height when exported to Excel
- SSRS trim trailing 0's from double
- Multiple Datasets from Stored Procedure in SSRS
- How do I format date on ssrs report?
- Data Source Not Visible in SSRS Report Manager
- Setting conditional colors per task age
- Report formula for Over90Days
- Keep report header visible while scrolling
- SSRS: Report subscription ran on off-cycle schedule
- Sum result of Sum of textboxes SSRS
- How to update SSRS textbox when database table value/string changes
- Strategies for populating a Reporting/Data Warehouse database
- SSRS Subscriptions - Windows Share Error: Failure writing file: XXX : The network name cannot be found
- Generate report from URL - SQL Server Reporting Services 2008
- How can I add the French trademark symbol (MD)?
- SSRS Custom Assembly Doesn't Recieve Full Trust
- How do I format date and time on ssrs report?
- Change Visual Studio "Current regional settings" value
- How can I get Hebrew formatting (rtl) for my .rdl report
- Is there a way in SSRS to only display specific parts of a report when rendered in MHTML, vs when it is rendered in the Report Viewer?