Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 you
Solved! Go to Solution.
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.
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.
@HarveyM Try to disable "Show item with no data" option.
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
@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.
@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.
@Tahreem24 Sure, here is a snippet, the real data is 180 rows.
apiName | client-id-enforcement | cors | header-injection | header-removal | ip-whitelist | oauth | rate-limiting | jwt-validation | rate-limiting-sla-based |
api 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |
api 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |
api 3 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0 |
api 4 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 5 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 6 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |
api 7 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |
api 8 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 9 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 10 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 11 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 12 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 |
api 13 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
api 14 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 15 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 16 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 17 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 18 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
api 19 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
api 20 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |