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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Raman3456
Helper I
Helper I

Based on RLS selection need to show the shape buttons , is it possible?

Hi All,

 

I have 3 RLS roles , Based on RLS selection Shape got enable in the Report will it be possible ?

 

 

Regards,

Raman

3 REPLIES 3
v-yangliu-msft
Community Support
Community Support

Hi  @Raman3456 ,

It is not possible to display Shape through RLS, but it can be filled with transparent color through Shape and measure to achieve no display

Here are the steps you can follow:

1. Create measure.

Make Transparent =
IF(
USERNAME()="Here is the name of your Username ",
"#FFFFFF00"
)

2. In Format shape, find Fill – fx.

vyangliumsft_0-1625646792380.png

3. Format by – Field value, Based on field select measure

vyangliumsft_1-1625646792383.png

On the host of your username, the shape is transparent to achieve no display.

 

This is the related document, you can view this content:

https://www.powerbi-pro.com/en/power-bi-display-measures-for-specific-users-only/

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

amitchandak
Super User
Super User

@Raman3456 , I doubt you can control the shape of the button using a measure. Because if that is possible we can do it using RLS.

Hi Amit,

 

Thanks for the reply , My question is if i select any value in the RLS , That shape only it should be appear 

it should be apply as automatically .

Can you tell me breifly ?

 

Regards,

Raman

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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