Viewer

Importing a Visual

Power BI uses interactive visualizations to present insights uncovered within your data. The visual specifically allows you to load a Data Exchange model directly from the viewer file included with your dataset. This simplifies access to valuable data by eliminating the need for separate model file management.

1. Open Power BI Desktop software.

2. Click More (...) menu in the Power BI desktop Visualizations pane.

3. Click Import a visual from a file from the drop-down list.

   

4. Select C:\Users<UserName>\Documents\Power BI Desktop\Custom Visuals\Autodesk Data Connector for PowerBI.pbiviz and click Open.

5. After the successful visual import, click OK.

   

6. Click the Autodesk Data Connector icon to load the viewer.

   

7. Search for the "data source name.viewer" column in the Data pane.

8. Drag and drop the "data source name.viewer" column to Viewer field. Note: If passing multiple .viewer columns, a relationship between those tables is mandatory.

   

9. Similarly, Search for the "ExternalElementId" in the Data pane.

10. Drag and drop the "ExternalElementId" to ExternalElementId-1 and ExternalElementId-2 fields.

    Important:
    • To map elements effectively, ensure that the "ExternalElementId" is used in all fields. If that fails, "Element ID" should be used as a fallback.
    • If you pass the viewer data, ExternalElementId-1 and ExternalElementId-2, and then pass the second viewer data, you need to pass the ExternalElementId-1 and ExternalElementId-2; then the model can be visible in the viewer.

11. The selected model loads in the viewer.

    

Coloring

Power BI empowers you to visually differentiate data points using the coloring feature. This intuitive tool allows you to assign distinct colors to objects based on their designated categories, specified in the "Color" field. This color-coding technique effectively categorizes your data, enhancing both visual clarity and information comprehension.

1. Search for categorical columns such as "Family", "Level", or "Category" in the Data pane.

2. Drag and drop the categorical column in the Color field. When you add the Color field, the visual assigns random colors to each distinct object.

   

3. Navigate to the Format menu in the Visualizations pane and expand Data Colors to assign the specific colors.

4. Select the required colors for various objects. The chosen color will be applied to all selected objects.

   

5. Alternatively, you can apply colors by setting conditions directly in the 'Conditional Colors' section.

6. Click the 'fx' icon to define the rules based on which colors should be applied to the data.

1. To reset the model to the original view, clear the Color field to remove colors.

Highlight Objects

The highlight feature provides a powerful way to isolate and examine specific data points within a visual. When you use this feature, the relevant data point is accentuated, while the remaining data remains visible but subdued. This allows you to focus on specific insights within your data without losing context.

1. Select the required visual in the Visualizations pane such as Pie chart, Donut chart, Bar chart, and so on. You can select multiple visuals.

2. Search the required categorical columns in the Data pane.

3. Drag and drop the categorical column to the respective fields in the Visualizations pane.

4. Select an object from another visual. It highlights and separates the object in viewer as shown in the following image.

   

5. Select an object from viewer. It highlights and separates the object in other visuals.

6. Select a group of objects from a visual. It highlights and separates the objects in viewer, and filters them out in other visuals.

   

Isolate or Ghosting

A feature that makes selected nodes in a model transparent, allowing other nodes to become more prominent. This feature is very useful to isolate specific objects from the entire model. With this feature, you can use "Slicers" and "Filters" to Filter out elements from viewer.

1. Select the Slicer visual from the Visualizations pane.

   

2. Search for categorical columns such as "Family", "Level", or "Category" in the Data pane.

3. Drag and drop the categorical column to the respective field in the Visualizations pane to create a Slicer.

4. Select the required category. It isolates the selected elements as shown in the following image.

   

5. For Filters, use any categorical column such as "Family", "Level", or "Category". It applies the filter on the viewer.

   

6. To reset the model to the original view, clear any active filter or slicer.

   

Removing a Visual from Power BI

1. Open Power BI Desktop software.

2. Click the More (...) menu in the Visualizations pane.

3. Click Remove a visual from the drop-down list.

   

4. Select Autodesk Data Connector and click Remove. It removes the visual from viewer.