Forum Discussion
Column chart visual data color conditional formatting not working when slicing the visual
Anonymous It seems that we have a bug here or the percentage is calculated in a way I don't understand.
For the others what have I done - I changed the formatting rules and used numbers instead of percentages (0, 0.9, 1).
It worked then...
BR,
Josef
Sorry, just reliased the ActualDownTime and ActualUpTime in the Events table was of the wrong format.
Try using this Events Table instead:
| EqpDateKey | Eqp_Plan_ID | Event_ID | Actual_Down_Time | Actual_Up_Time | DownTime | Description | Breakdown |
| 1074 - 2019-06-20 | 1074 | 107142 | 20-06-19 06:00 | 20-06-19 06:00 | 0 | WT2066: Steering Components Inspection - NDT ( PO 52384 ) | FALSE |
| 1074 - 2019-06-25 | 1074 | 106831 | 25-06-19 20:00 | 26-06-19 03:00 | 420 | WT2066: BLOWN A/C COMPRESSOR | TRUE |
| 1074 - 2019-06-28 | 1074 | 106812 | 28-06-19 09:15 | 28-06-19 09:45 | 30 | WT2066 - FIRE SUPPRESSION INSPECTION - 6 MONTHLY (L1) Dont move FSI are booked | FALSE |
| 1074 - 2019-07-14 | 1074 | 107730 | 14-07-19 21:00 | 14-07-19 22:00 | 60 | WT2066 - Sprays not working | TRUE |
| 1074 - 2019-07-23 | 1074 | 105051 | 23-07-19 06:00 | 24-07-19 04:00 | 1320 | WT2066: 500 HOUR SERVICE - KIT | FALSE |
| 1074 - 2019-07-28 | 1074 | 108437 | 28-07-19 08:30 | 28-07-19 12:30 | 240 | WT2066 - Wont start | TRUE |
| 1074 - 2019-07-31 | 1074 | 108526 | 31-07-19 01:00 | 31-07-19 01:00 | 0 | WT2066: C SAMPLE WHEEL HUB LEFT | TRUE |
| 1074 - 2019-08-16 | 1074 | 109401 | 16-08-19 07:00 | 16-08-19 09:00 | 120 | WT2066 Brake Test - Fully Loaded | FALSE |
| 1074 - 2019-08-16 | 1074 | 105056 | 16-08-19 18:00 | 17-08-19 06:00 | 720 | WT2066: 250 HOUR SERVICE / | FALSE |
| 1074 - 2019-09-03 | 1074 | 110518 | 03-09-19 08:00 | 03-09-19 08:00 | 0 | WT2066: Site Compliance Inspection (FRC) | FALSE |
| 1074 - 2019-09-05 | 1074 | 109568 | 05-09-19 18:00 | 08-09-19 00:00 | 3240 | WT2066: 2000 HOUR SERVICE - KIT/ Hoses 24 are booked in for the 06/09/2019 6am start. | FALSE |
| 1074 - 2019-09-09 | 1074 | 110937 | 09-09-19 18:00 | 10-09-19 00:00 | 360 | WT2066 Horn not working | TRUE |
| 1074 - 2019-09-12 | 1074 | 111077 | 12-09-19 10:18 | 12-09-19 10:18 | 0 | WT2066 Steering Components Inspection - NDT PO 58905 | FALSE |
| 1075 - 2019-06-18 | 1075 | 106460 | 18-06-19 07:45 | 18-06-19 20:22 | 757 | Coolant C Sample | TRUE |
| 1075 - 2019-06-20 | 1075 | 106562 | 20-06-19 07:00 | 20-06-19 07:30 | 30 | Low coolant | TRUE |
| 1075 - 2019-06-29 | 1075 | 106988 | 29-06-19 13:00 | 29-06-19 14:30 | 90 | Aircon fan U/S | TRUE |
| 1075 - 2019-07-02 | 1075 | 106547 | 02-07-19 06:00 | 03-07-19 13:20 | 1880 | DT2630: 250 Hour Service | FALSE |
| 1075 - 2019-07-17 | 1075 | 107842 | 17-07-19 06:00 | 17-07-19 11:15 | 315 | Fire suppression fault | FALSE |
| 1075 - 2019-07-17 | 1075 | 107901 | 17-07-19 16:00 | 17-07-19 16:20 | 20 | Air start | FALSE |
| 1075 - 2019-07-18 | 1075 | 107916 | 18-07-19 07:45 | 18-07-19 10:00 | 135 | Lost cab power | FALSE |
| 1075 - 2019-07-19 | 1075 | 107951 | 19-07-19 08:20 | 19-07-19 08:35 | 15 | Start fault | FALSE |
| 1075 - 2019-07-26 | 1075 | 106527 | 26-07-19 07:10 | 27-07-19 04:30 | 1280 | DT2630: 2000 Hour Service | FALSE |
| 1075 - 2019-08-08 | 1075 | 109094 | 08-08-19 18:45 | 08-08-19 19:15 | 30 | Air Start | TRUE |
| 1075 - 2019-08-13 | 1075 | 109332 | 13-08-19 06:50 | 13-08-19 07:30 | 40 | Door Alarm Staying on | TRUE |
| 1075 - 2019-08-19 | 1075 | 109691 | 19-08-19 19:00 | 19-08-19 19:55 | 55 | TC Filter Plugged | TRUE |
| 1075 - 2019-08-21 | 1075 | 108666 | 21-08-19 06:00 | 21-08-19 18:00 | 720 | DT2630: 250 Hour Service | FALSE |
| 1075 - 2019-09-03 | 1075 | 110606 | 03-09-19 19:30 | 03-09-19 20:00 | 30 | Park brake slow to release | TRUE |
| 1075 - 2019-09-04 | 1075 | 110612 | 04-09-19 04:19 | 13-09-19 09:55 | 13296 | Park brake not releasing | TRUE |
| 1076 - 2019-06-16 | 1076 | 106332 | 16-06-19 06:55 | 16-06-19 07:25 | 30 | Air Start | TRUE |
| 1076 - 2019-06-20 | 1076 | 106593 | 20-06-19 17:30 | 20-06-19 22:02 | 272 | Hydraulic Oil Leak | TRUE |
| 1076 - 2019-06-20 | 1076 | 106512 | 20-06-19 00:20 | 20-06-19 00:50 | 30 | Air Start | TRUE |
| 1076 - 2019-06-20 | 1076 | 105117 | 20-06-19 08:00 | 20-06-19 15:45 | 465 | DT2530 - Fire Suppression Service/Inspection L2 | FALSE |
| 1076 - 2019-06-23 | 1076 | 105590 | 23-06-19 06:00 | 23-06-19 17:30 | 690 | DT2530: DT2530 - 1000 Hour Service | FALSE |
| 1076 - 2019-06-28 | 1076 | 106954 | 28-06-19 07:15 | 28-06-19 10:10 | 175 | No start | TRUE |
| 1076 - 2019-06-30 | 1076 | 107014 | 30-06-19 13:55 | 30-06-19 14:25 | 30 | Air tap leaking | TRUE |
Anonymous
Many don't manage to provide sample data, so I thank you for that :smileyvery-happy:
I have built up a sample file, but I have the problem that the relationships don't seem to work properly.
I also believe that your relationships are the cause of the misbehaviour. (For example, is the filter direction properly defined in your model?)
So to get to the bottom of these errors, I need the Power BI file from you.
In this forum the file must be available as Link to an Ondrive/Google Drive whatever.
BR,
Josef
I've set up a DropBox but need your email address to share the file with you. Are you able to provide this?
Anonymous It seems that we have a bug here or the percentage is calculated in a way I don't understand.
For the others what have I done - I changed the formatting rules and used numbers instead of percentages (0, 0.9, 1).
It worked then...
BR,
Josef
Legend!
Such a simple fix... the data type for the measure was % and still is % when it works, but as you said, it only seems to color format correctly with the rule based on number rather than %.
Thanks for your help.