Make the button on page 1 green if there are values in the table on page 2

[Anonymous]

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 you

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Thanks for reaching to us.

First, you need a measure to get the table status, e.g.

HasValue = IF(COUNTROWS(ALLSELECTED('Table')),"Green","Red")

well, the measure depends on your need.

then, put it into Format Button  - Fill -

finally, enable Sync slicers

result

FYI:

https://www.wiseowl.co.uk/blog/s2722/conditional-format-button-properties.htm

Best Regards,

Community Support Team _ Tang

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

[jaideepnema]

Hi @Anonymous ,
Not very clear for me but is it possible for you to share a sample pbix with sensitive data removed ?

Regards,

Jaideep

[Anonymous]

My test file: sry i cant upload a pbix file.

on the Startpage there are 3 buttons that navigate to the pages (with Aktion/sitenavigate). If there are values in the table one page PCS (Screenshot below) , then the PCS button on the Startpage should be highlighted in green.

is that enough as a description ?