- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show Slicer Values based on the logged in user in Power BI
Dear Community,
I have a slicer with the list of cost centers. I want to display cost centers of the logged in user in the cost center slicer. How can I do this in power BI. I have created a visualization which filters the data based on the slicers selection. I do not want to show all the cost centers to the logged in user. I want to show the cost ceters to which they belong to or have access to.
Kindly share the knowledge!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Supritha1594 you can use Row-Level Security (RLS). Create a table showcasing user names and their corresponding accessible cost centers.
Navigate to the "Modeling" tab in Power BI Desktop and access "Manage Roles."
Initiate a new role by clicking on "Create."
Within the "Table Permissions" section, designate the table housing cost centers.
Move to the "Filter" section, opt for "Only show the rows where," and select the column with user names and cost centers. Save the role by clicking "OK."
Note:
Dallas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Supritha1594 I'm Happy to know it works. Kindly @ me with any future needs around Power BI and Fabric.
Dallas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Supritha1594 you can use Row-Level Security (RLS). Create a table showcasing user names and their corresponding accessible cost centers.
Navigate to the "Modeling" tab in Power BI Desktop and access "Manage Roles."
Initiate a new role by clicking on "Create."
Within the "Table Permissions" section, designate the table housing cost centers.
Move to the "Filter" section, opt for "Only show the rows where," and select the column with user names and cost centers. Save the role by clicking "OK."
Note:
Dallas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks alot @DallasBaba for your response! It really worked well...I followed the youtube video and the steps that you have mentioned above.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-26-2024 07:45 PM | |||
Anonymous
| 03-07-2024 04:38 AM | ||
06-14-2023 05:18 AM | |||
09-27-2022 11:01 AM | |||
03-19-2024 05:55 AM |
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
1 |