cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
harryli
Helper II
Helper II

How to make boolean values to be icons in table display

I would like to make the boolean value to be some awesome icons, but the result will become the following which is not following the rules. 

harryli_0-1654746178708.png

The resulting figure.

harryli_1-1654746217850.png

The rules setting.

 

harryli_2-1654746259700.png

The data source.

 

Thanks for the help.

 

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @harryli 

 

If you want to choose Sum in conditional formatting window, ensure the column is of Number type (whole number or decimal number). Only number-type columns can be aggregated with Sum.  

vjingzhang_0-1655174018375.png

 

Then in conditional formatting, select Icon only for Icon layout. 

vjingzhang_1-1655174393320.png

Hope this helps. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @harryli 

 

If you want to choose Sum in conditional formatting window, ensure the column is of Number type (whole number or decimal number). Only number-type columns can be aggregated with Sum.  

vjingzhang_0-1655174018375.png

 

Then in conditional formatting, select Icon only for Icon layout. 

vjingzhang_1-1655174393320.png

Hope this helps. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors