Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Fati99
Frequent Visitor

Equipment Running or shutdown

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 

477831E0-AAF4-499C-9981-8464BEA0BAC7.png

1 ACCEPTED SOLUTION
AnkitKukreja
Super User
Super User

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.

 

AnkitKukreja_0-1672075332554.png

 

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

View solution in original post

5 REPLIES 5
AnkitKukreja
Super User
Super User

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.

 

AnkitKukreja_0-1672075332554.png

 

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

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.

@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.

 

 

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

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.

PBI_SuperUser_Rank@1x.png  

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
Super User
Super User

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors