Forum Discussion

jovendeluna21's avatar
jovendeluna21
Helper IV
4 years ago
Solved

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

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 
 
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

     

4 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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's avatar
      jovendeluna21
      Helper IV
      4 years ago

      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's avatar
        v-kkf-msft
        Community Support
        4 years ago

        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.