- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 you
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@HarveyM Try to disable "Show item with no data" option.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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 |
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
06-24-2024 10:32 AM | |||
10-23-2024 09:02 AM | |||
10-18-2024 11:29 PM | |||
10-11-2024 05:25 AM | |||
07-30-2024 09:25 AM |
User | Count |
---|---|
118 | |
73 | |
56 | |
56 | |
43 |
User | Count |
---|---|
181 | |
121 | |
82 | |
69 | |
54 |