Conditional Page Navigation with RLS, button color should change when certain page is selected

[jovendeluna21]

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

Button 1 Color = SWITCH([Button 1 Destination],

SELECTEDVALUE('Page Current Selector'[Page Name]), "#2DA2BF",

BLANK(),"White",

"#B3B3B3")

For example 

[v-kkf-msft]

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.

[jovendeluna21]

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.

[v-kkf-msft · Accepted 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.

[jovendeluna21]

Oh that's simple as it is. Great! Thanks for your help @v-kkf-msft !!!