cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dom898
Regular Visitor

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

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

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @Dom898 

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 -

vxiaotang_0-1634092428328.png

finally, enable Sync slicers

vxiaotang_1-1634092580155.png

result

vxiaotang_2-1634092951757.gif

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.

View solution in original post

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @Dom898 

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 -

vxiaotang_0-1634092428328.png

finally, enable Sync slicers

vxiaotang_1-1634092580155.png

result

vxiaotang_2-1634092951757.gif

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
Super User
Super User

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

 

Regards,

Jaideep

Dom898_0-1633968446137.png

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.

 

Dom898_1-1633968518838.png

 

is that enough as a description ?

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!