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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
AspireCraig
New Member

Changing Boolean field to Checkmark - Icon

Hello everyone,

in my query I have a boolean field, 1-0, 0=false, 1=true. On my power Bi matrix I would like to display this in a checkbox style instead if displaying 0 and 1s. I have tried using conditional formating but unable to acheive this desired result. Can anyone shed light how I can accomplish this? 

 

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Hello @AspireCraig 

If you pull your value field into the matix then set the conditional formatting like this you should get what you are looking for.  If you only want to display the icons make sure to set the Icon layout field to "Icons only":

checkmarks.jpg

View solution in original post

1 REPLY 1
jdbuchanan71
Super User
Super User

Hello @AspireCraig 

If you pull your value field into the matix then set the conditional formatting like this you should get what you are looking for.  If you only want to display the icons make sure to set the Icon layout field to "Icons only":

checkmarks.jpg

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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