Conditionnal formating of a button if number of specific values are above 0

[Sibrulotte]

Hi, 

I have a client list. Each client has a "Yes" or "No" value in column R001. I'm trying to get creative on a way to show a red color on a button if there are > 0 clients with a "Yes" value in the column R001.

Does anyone have an idea for that?

[Sibrulotte]

The problem is the function in all conditionnal formating is not DAX.

It's either Gradient, rule or filed value and none of them helps me get to my goal.

Right now I'm trying to use a table with cell elements that has the proper conditionnal formating rules. But then I'd like a button for my user to investigate and open another table, so I'm not that much further ahead.

[VijayP]

@Sibrulotte  You question is incomplete

What button you are adding is it bookmark , navigation?

you can change the button color dynamically using conditional formatting, using DAX