Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys, i wanna do a trick that will dynamically color the row in a table (or the bar in a chart) concerning the user accessing my report.
Example : a table with all the countries in Europe. The guy from France get connected to the report, bing, France row appears yellow when the report first appears. No click needed. My user doesn't have to search for France row, the report shows it at first look.
If Marco opens the same report, then Italy line will show up in yellow.
My searches and tries lead to a complex solution (i didn't even tried yet) :
- import my fact table
- duplicate it in dax
- filter the first one with RLS = user country
- filter the second one with RLS <> user country
- append both
>> Pros: i should be able to build a flag "my country" that'll do the trick
>> Cons: too complex for a simple need, and it's a memory waste cause i only use the append table...
Thanks for your help
PS. we can't use 'USERPRINCIPALNAME()' with calc column, otherwise the solution would be pretty straightforward
Solved! Go to Solution.
@Anonymous
There is a possibility to achieve by mapping the USERNAME() and COUNTRY on a table. Watch the following video for the explanation and adapt it to your need.
https://www.youtube.com/watch?v=uuwxWnAILr0
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
When you use RLS , The data will be masked and be shown only France data to France Guy and Italy Data to Italy Guy.
Still do you require this option? Trying to understand the usability perspective and effectiveness
Vijay Perepa
Proud to be a Super User!
yes if i use RLS the classic way
but in my option, i would use the RLS to get 2 opposite views of my full table :
- view #1 : the rows the user should see (or the rows that should get highlighted)
- view #2 : the rows that shoud get greyed-out (but the user can see them for benchmark)
@Anonymous
There is a possibility to achieve by mapping the USERNAME() and COUNTRY on a table. Watch the following video for the explanation and adapt it to your need.
https://www.youtube.com/watch?v=uuwxWnAILr0
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
1st seconds of the video are promising !!! thanks
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |