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.
