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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Raman3456
Helper II
Helper II

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.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!