2 February 2018

Power BI: Using The Synoptic Panel

The Synoptic Panel by SQLBI is a visual component useful for various visuals.

It allows us to define areas in a picture chosen by the user as well as to define different colours for different areas, filling each area with a colour or saturation of a colour related to another value or measure.

1.1. SYNOPTIC PANEL

Synoptic Designer is a web application that works in any modern browser (IE 10+, Edge, Chrome, Firefox and Safari) and highlights the areas of the Traffic Light or Map.

Select a tool in the bottom panel and click the image to define new area points.

 

1.2. PRATICAL GUIDE

1.1.1. FIRST STEPS:

1.1.2. SYNOPTIC DESIGNER FOR POWER BI

In the website: http://synoptic.design/

- 1: Import the "trafficlight" image that you want to format.

 

- 2: Configure, delineating what each area is, in this case, areas 1, 2 and 3 (right, center and left respectively).

When defining the areas, we have to ensure that each one has the same content of the measure column in this case (1, 2 and 3)

- 3: Export the image "trafficlight" (Download SVG)

1.1.3. IMPORT CUSTOM VISUAL

> synopticPanelByOKViz-1.4.6B.pbiviz after importing the pbiviz file;

 

> Choose a local map file, in this case our image trafficlight.svg

> Define a measure that will define the results and define the states of the metric

 

When the metric takes the result trend equal to 3 was the area that we defined more to the left,

 

For state 2, it will fill area 2 respectively,

 

For state 1,

 

 

1.3. CONCLUSIONS

Although the site itself synoptic DESIGNER FOR POWER BI is able to automatically fill in the areas, it becomes difficult sometimes when we want something more customized, for example, set in a circle one half and another half.

In relation to the pbiviz file imported into the Power BI, it did not give complications although it did not exploit ¼ of the functionalities. The goal was to create a three colours semaphore for three states that in this case enabled us to define each one in different areas.

Blog