Equipment Running or shutdown

[Fati99]

Hii, 

I would like to use a visual to show if a chosen pump is running or not based on 0 and 1 at a given time. 

0 = shutdown 

1= running 

It can either be a colored square or a "Running/Shutdown" text

This is how my query looks like 

[AnkitKukreja · Accepted solution]

Hi @Fati99 

As your data has a single value you can either replace the value in the query editor to Running/shut down and use the colour formatting. Attaching the sample file for your reference.

[Fati99]

So the only visual I can use would be the table visual?

I wanted to use a nicer visual to show if the pump is running or not in a certain time.

[AnkitKukreja]

@Fati99 

You can try with other visuals but a table/matrix would give you the best result showcasing date and pump data as well. I have worked on Alexis Olson's advice and I did unpivot this data and have used conditional formatting. Please see if this helps.

[Anand24]

Hi @Fati99 ,
I guess the best and simplest way to represent would be through table visualization with conditional formatting.
To make it visually better, you can apply same conditional formatting for font color and background color and then provide a legend somewhere indicating what green and red would mean.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[AlexisOlson]

I'd recommend unpivoting the pump columns before loading your data. It should be easier to work with that way.

https://learn.microsoft.com/en-us/power-query/unpivot-column