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
yacheou
Frequent Visitor

Plotting Individual Dots on Floor Plan and Display Data

Hi Everyone,

 

 

Before I go to the problem that I face, allow me to explain a little bit about what I'm trying to do.

 

Currently what I have is a layout of the floor plan, for example:

 

floor-house-plan.jpg

And I have a set of data from an Excel file, for example:

 

yacheou_1-1665590434158.png

 

This data will be used to mark the zones in the floor plan, the electrical items that are in the zones, and the status of electrical items whether they are switched off (Offline) or switched on (Online). What I try to achieve in Power BI dashboard is, a floor plan that displays the Zones in which every zone has its electrical items (HSE_Item01, HSE_Item02, ...), and shows the status of every item whether they are Offline or Online (thinking about on how to Color Code it as well, as such Offline = Red and Online = Green).

 

 

So, from what I have found, Synoptic Designer + Synoptic Panel for Power BI might be suitable visual to:

 

1) Mark the zones in the floor plan.

2) Plot individual dots in the floor plan (for the location of each electrical item).

 

For marking the zones in the floor plan, I didn't find much trouble displaying data because it has Tooltips, like this:

 

(This image is for example only to show Tooltips)

area-tooltips.png

Because when marking areas with Synoptic Designer will enable Tooltips in Synoptic Panel for Power BI.

 

But for plotting individual dots in the floor plan, what I have done in Synoptic Designer is like this:

dot-synoptic.png

 

So when I put it together in Synoptic Panel for Power BI, the result that I got is this:

 

1.png

It is quite messy because the texts are overlapping. I was wondering if it is possible to use tooltips to overcome this problem because when I try to hover the mouse on the text/dots location, there are no tooltips appear.

 

Other alternative solutions or visual recommendations are very much welcome as well.

 

 

Thank you very much in advance.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1 REPLY 1
lbendlin
Super User
Super User

That's not what Power BI is for. Use a more appropriate tool that is specidfically designed for building management.

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