topic Re: can we create dynamically dax for page navigation in power bi? in DAX Commands and Tips

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

Anonymous — Mon, 06 Jun 2022 11:19:59 GMT

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?

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

SpartaBI — Mon, 06 Jun 2022 16:50:42 GMT

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

Showcase Report – Contoso By SpartaBI

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

Anonymous — Thu, 09 Jun 2022 07:01:49 GMT

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.

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

Anonymous — Mon, 13 Jun 2022 12:34:21 GMT

Hi,

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