Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Highlight User's concerning row

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

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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 🙂

YouTube  LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
VijayP
Super User
Super User

@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




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Anonymous
Not applicable

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)

Fowmy
Super User
Super User

@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 🙂

YouTube  LinkedIn

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

1st seconds of the video are promising !!! thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.