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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors