Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I would like to compare a workflow (wf) finish time with the target time and highlight the finish time when it passes the target time. The Finish Time is in hh.mm format, for instance 05:00pm. I would like to compare it with the target time, i.e. 07:00pm. However, when I tried to do the Conditional Formating for WF Finish Time, I was only given the option of Count of WF Finish Time, instead of the actual value of the Finish Time. Is there anyway to do conditional formatting for time?
Solved! Go to Solution.
@HelenaX Might have to convert the time to a number in a new column/measure and base the conditional formatting on that. Some links are below for that but in your case, you might be able to create a copy of the column and just change the data type.
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92
It is very strange. I had to post my replies 3 times and first 2 replies simply disappeared after I clicked "Post". This is not the first time I experienced this in this community. Also, I couldn't do a Thumb Up. Was there a restriction on the number of thumbs a solution can have?
@Greg_Deckler That works!! I was able to create a measure to convert the time to a number:
@HelenaX Might have to convert the time to a number in a new column/measure and base the conditional formatting on that. Some links are below for that but in your case, you might be able to create a copy of the column and just change the data type.
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |