Highlight and isolate objects in Power BI visuals

00:03

Using the Power BI Connector to load an Autodesk Data Exchange into Power BI

00:08

enables you to create customized reports and dashboards to assist with data analysis.

00:13

Once you add Power BI visuals to your dashboard,

00:17

you can highlight and isolate specific objects to display and review only the corresponding data.

00:22

Start in the Power BI desktop application with a Data Exchange imported, the Autodesk Data Connector viewer loaded,

00:29

and a visual already created.

00:32

For this example, a Stacked Column Chart visual shows the area sum by floor type.

00:38

Select an element in the viewer—in this case, a floor—and in the stacked column chart,

00:44

the specific portion of the bar for the corresponding property type appears highlighted.

00:48

If you have other visuals on your dashboard, the selected object is highlighted there as well.

00:54

To clear the selection, click an empty space in the viewer.

00:58

Similarly, select a bar from the chart, and all elements of that property type appear highlighted in the viewer and in other visuals.

01:07

To remove the highlights, click the column again.

01:10

You can also isolate specific elements by adding a Slicer visual to your Power BI dashboard.

01:17

In the Visualizations pane, ensure that no other visuals are selected, and then select Slicer.

01:24

A Slicer visual displays on the dashboard.

01:26

In the Visualizations group, the Slicer has only one Field used to filter out selected elements from the Data Exchange.

01:34

In the Data pane, locate the property you want to filter by—in this case, type—then drag it into the Add data fields here field.

01:43

The Slicer visual updates with a list of types.

01:47

Here, to narrow the results to only floor types, drag category from the Data pane into the Filters on this visual group

01:54

and drop it in the available field.

01:57

Then, in the filter options, select Floors.

02:02

Now, the Slicer displays only property types categorized as Floors.

02:07

Select a property type, such as Finish Floor – Polished Concrete (Brown),

02:13

and the viewer isolates the selected property type, with other property types now only slightly visible, or ghosted.

02:19

To hide the other property types entirely, in the viewer, click Settings, and then toggle OFF Ghost Hidden Objects.

02:28

The viewer updates to show only the isolated elements.

02:33

Close the Settings dialog.

02:36

Now you can highlight and isolate objects within the visuals displayed on your Power BI dashboard.