Highlight start page button in color if there are values on another page

[Dom898]

Hallo,

my question is: 

I have a report with several pages and on the first page (start page) there are text fields as buttons that link to the other pages. On the other pages are tables with values. But the tables do not always contain values.

Now I want that if in a table values are contained the button on the start page is displayed in green.

Does anyone have an idea ?

Thank youdfd

[Eyelyn9 · Accepted solution]

Hi @Dom898 ,

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

Navigate button = SWITCH(MAX('Page Name'[Value]),"Overview","Green","District Monthly Sales","Red","New Stores","Yellow")

Create buttons in Power BI reports - Power BI | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Dom898 , there are Page navigation buttons, drill through buttons or bookmark buttons?

[Dom898]

page navigation buttons