can we create dynamically dax for page navigation in power bi?

[Anonymous]

The selected and enabled tab should be green and disabled tab should be red and data should not be visible. how can we make dynamic page navigation using DAX?

[v-yangliu-msft]

Hi  @Anonymous ,

You may need to firstly define which pages on the Table visual has no value, and then use Conditioanl Formatting on Background color:

Follow the link below to create Buttons and which page to navigate:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-buttons?tabs=powerbi-desktop#create-page-navigation

Then use measure to select the fx of Background color to customize the color:

Navigate button =
SWITCH(
    MAX('Page Name'[Value]),"Not data","Red","data","Green")

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Conditional-Page-Navigation-with-RLS-button-color-should-change/td-p/2277101

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.

[SpartaBI]

@Anonymous check out these video:
https://www.youtube.com/watch?v=-kaUnBXvvGo

Showcase Report – Contoso By SpartaBI

      

[Anonymous]

Hi,

Thanks for replying it is not working what I am expecting.