Filtering data on selected language
Hi, I'm trying to create a multi-language report based on the USERCULTURE(). I started by creating a measure: Selected_Language = LEFT(USERCULTURE(),2) This returns the language: en, nl, fr, ... I have an overview of events, each containing a code for department, function, ... I imported an excel containing "codes" and their translations for certain tables: Department Function Based on the selected_language measure, I would like to display the correct value for department and function for each event. I created un unpivoted table "Safety codes" containing all codes: I created a parameter "Language" that I used to filter on role level: This seems to be working fine: However, to be able to use this approach, the user needs to be a viewer, not a member or contributer. But as a viewer, the user is not able to pin certain visuals to a dashboard. Any idea how to fix this? Or is there another approach? Without the RLS filtering, the values in all languages are shown: Thanks for some feedback on this.
RLS based on 3 columns (All possible combinations)
Hi All, Looking to implement RLS that is based on 3 columns. So all possible combinations must be taken in to account while filtering. Consider the below table, the user could fall in either: - None of the columns, OR - Any 1 column, OR - Any 2 columns, OR - All 3 columns I am using an excel to capture the role against email IDs but can't crack the DAX yet in Manage Roles, any leads with the DAX will be really helpful.Dynamic RLS for users based on a column value with non-unique values
Hello everyone, I'm trying to implement a holiday tracking PowerBI Report that has a dimension table with all the staff names and their respective department, please see below for an example: I was wondering if there was any DAX I can use in the RLS Security Role Editor to dynamically filter the report to the department based on the user that is accessing the report. So say if Staff Member A was the view the report, all the visuals would be dynamically filtered to be Department 1 instead of just for Staff Member A. Similar to if Staff Member H was to view the report, the visuals would be filtered to be Department 5 It needs to be set up this way so everyone in a single department can view other staff members holiday within that department, however users should not be able to see holidays cross-department. The only workaround I can currently think of is to create a Security Role PER Deparment and add each user manually to each security role (please see below), however we have an exponentially increasing Staff Dimension table so this way will result in alot of manual overhead from our administrator. It is also worth noting that within the staff table of the report we store an email adress in the idential format to what the USERPRINCIPALNAME() function outputs. So in an ideal world I would have 1 Security Role we can add people to, the report would then extract the value for whichever department is assigned to that staff member based on USERPRINCIPALNAME(), and then filter the report to whatever department that staff member is assigned to Any help is much appreciated
using slicer to highlight only the values of the selection
Hi, I know the basic concepts of Row Level Security (RLS) where selected users can see only their relevant data while other users data will be completely blinded. But I want to show other users data to the selected user while their name will be blinded but not the data values. So, the idea is when I select a user from the slicer it will show PBI visuals with the relevant data of all users but mask will other users name. Not sure if it can be doable in other ways, feel free to share your ideas here here is the following visual that I want to implement:
