Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I just need help, I don't know why button color doesn't change when certain page is selected and when changing the roles for RLS button not changing to white those button not viewable for specific role.
I have attached herewith the pbi file.
https://drive.google.com/file/d/1baDMJWcN8XwzD61Rx_WbkPjHqoMzAQbk/view?usp=sharing
Solved! Go to Solution.
Hi @jovendeluna21 ,
You need to add the correct page-level filter for each page using the Page Current Selector[Page Name] field, like this:
The result:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jovendeluna21 ,
Because SELECTEDVALUE('Page Current Selector'[Page Name]) returns blank, so [Button 3 Destination] = SELECTEDVALUE('Page Current Selector'[Page Name]) = Blank(), the [Button 3 Color] measure returns "#2DA2BF".
Please try the following measures:
Button 1 Color = SWITCH([Button 1 Destination],
BLANK(),"Whiter",
SELECTEDVALUE('Page Current Selector'[Page Name]), "#2DA2BF",
"#B3B3B3")
Button 2 Color = SWITCH([Button 2 Destination],
BLANK(),"Whiter",
SELECTEDVALUE('Page Current Selector'[Page Name]), "#2DA2BF",
"#B3B3B3")
Button 3 Color = SWITCH([Button 3 Destination],
BLANK(),"Whiter",
SELECTEDVALUE('Page Current Selector'[Page Name]), "#2DA2BF",
"#B3B3B3")
Button 4 Color = SWITCH([Button 4 Destination],
BLANK(),"Whiter",
SELECTEDVALUE('Page Current Selector'[Page Name]), "#2DA2BF",
"#B3B3B3")
Button 5 Color = SWITCH([Button 5 Destination],
BLANK(),"Whiter",
SELECTEDVALUE('Page Current Selector'[Page Name]), "#2DA2BF",
"#B3B3B3")
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much @v-kkf-msft! However I want also the button of the current page selection to be in blue color. For example if you are viewing Automation Solutions, the button Automation Solutions will be blue and the homepage is gray, but if you switch to Homepage, the Homepage button will be blue and Automation Solutions will be in gray.
Hi @jovendeluna21 ,
You need to add the correct page-level filter for each page using the Page Current Selector[Page Name] field, like this:
The result:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |