Showing seconds in a visual

[Jmccoy]

I am putting into visuals the health of our servers for my developer to monitor without having to look through tables in SQL. 

There is one visual I need help putting together, I can not seem to figure out the best way to go about it. 

first time reading: EX. 2020-06-05 14:15:47.000

second time reading: EX. 2020-06-05 14:15:54.000

These are two columns that that find the difference in time it took for a command to run in a program on our 6 difference servers. 

So far in Power BI, I have found the difference between the two and made another column called time diff. I am trying to make a visual that shows each server and TimeDiff value. This table I am using only has 6 rows for each server and does not keep track of historical data. As soon as the command fires, the first time and seconds time are constantly being replaced by new values. 

I am being told all the he cares about is if the time between commands stays between a certain range. He wants it to change color as the time increases. 2-5 seconds is ideal- green, 5-10 seconds - Orange , 10+ is red. 

[Anonymous · Accepted solution]

@Jmccoy 

You can use Second() function to take out the Seconds from the Time column. Then use the measure to rule the conditional formatting.

Sec = Second([Time Column])

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Jmccoy ,

You can use the conditional formatting function in the table to set the color that you want.

Aiolos Zhao