Forum Discussion
Conditional Page Navigation with RLS, button color should change when certain page is selected
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.Oh that's simple as it is. Great! Thanks for your help v-kkf-msft !!!