Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
iingemann
New Member

I can't seem to make a button unclickable

Hello experts,

 

I have created a measure outputting a binary value and based on that I want to make a button available if 1 or unavailable if 0.

 

Using conditional formatting I can colour button and button text to the background colour - thereby hiding the button. But it's still clickable, which is not good.

 

iingemann_0-1697034632467.png

When I go into actions on the button and hit the conditional formatting button I see this:

iingemann_1-1697034680585.png

When I pick my binary measure nothing happens, so something is not working.

 

And pardon the Danish screenshots, but I work in a place where software is changed globally for some reason - for example not letting me get Power BI in English, which is also why I'm also scared my functionalities in Power BI has been limited in some way.

But it might just be me being stupid. 🙂 

 

Thanks in advance!

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@iingemann , You need to have a measure that returns text to use the field value conditional formatting.

if it returns 0 or 1 then use rule-based

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@iingemann , You need to have a measure that returns text to use the field value conditional formatting.

if it returns 0 or 1 then use rule-based

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.