Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hi All,
I have 3 RLS roles , Based on RLS selection Shape got enable in the Report will it be possible ?
Regards,
Raman
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.
3. Format by – Field value, Based on field select measure
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
@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
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |