Reply
HarveyM
Helper I
Helper I
Partially syndicated - Outbound

Conditional Formatting Display issues

Hi, I have a data table, with API names, policies, if the policy is enabled, there is a value of 1, if disabled a value of 0, every single record has either a 0 or a 1, there are no errors or null values. The data type is numbers.

I have applied conditional fomratting correctly, if there is a 1 show a tick, if there is a 0 show a cross. This has worked, however the formatting is not displaying on all records.

When I hover over the empty boxes, it shows me that there is either a 0 or 1, it just will not display the icon.

I have attached an image of the error any advice is appreciated.

 

Thank youconditional formatting issue.png

1 ACCEPTED SOLUTION
HarveyM
Helper I
Helper I

Syndicated - Outbound

Solution - Although whole numbers were being used, the sum of the single cells in some cases were not equal to 1. Once switched over to cell average, all cells conditional formatting was displayed correcrly. 

View solution in original post

6 REPLIES 6
HarveyM
Helper I
Helper I

Syndicated - Outbound

Solution - Although whole numbers were being used, the sum of the single cells in some cases were not equal to 1. Once switched over to cell average, all cells conditional formatting was displayed correcrly. 

Tahreem24
Super User
Super User

Syndicated - Outbound

@HarveyM Try to disable "Show item with no data" option.

Capture.JPG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Syndicated - Outbound

Hi @Tahreem24 

 

This was already disabled. I enabled it, and turned it off again, but there was no difference.

There are no items with no data, every field is populated.

 

Thank you

Syndicated - Outbound

@HarveyM  Can you able to share some sample data which contains atleast 10-15 rows so that I can check this out at my end.

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Syndicated - Outbound

@Tahreem24 sure, I have had to upload a picture as my message automatically deletes every time I use a table. I hope this is suitable. There are 170 rows in the full sheet.sample data.png

Syndicated - Outbound

@Tahreem24 Sure, here is a snippet, the real data is 180 rows.

apiNameclient-id-enforcementcorsheader-injectionheader-removalip-whitelistoauthrate-limitingjwt-validationrate-limiting-sla-based
api 1100000110
api 2000000110
api 3010101100
api 4010001100
api 5100001100
api 6100000110
api 7100000110
api 8100001100
api 9100001100
api 10100001100
api 11100001100
api 12100011100
api 13100001000
api 14100001100
api 15000001100
api 16100001100
api 17100001100
api 18100001000
api 19100001100
api 20100001100
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)