Visualize live connection status (Success or Failed )

Hi Sajid02 ,

I think in Powerbi you can colorize data that is static. For what you mentioned in your description, I think that after you run the data, you can import the data into Powerbi and colorize it using Conditional formatting.

Firstly I create a table as you mentioned.

Then I create a measure and here is the DAX code:

Color = IF(MAX('Table'[Status])="FAILED","Red","Green")

Finally you will get what you want.

 

 

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.