New Feature – Conditional Formatting in 3DBI

Nov 17, 2022 | how-to-3dbi, how-to-3dbi-revit, how-to-3dbi-sketchup | 0 comments

Conditional Formatting?

In this tutorial you will learn how to add conditional formatting to your 3DBI models in Microsoft® Power BI®. With conditional formatting you can specify customized object colors, including color gradients, based on field values. You can apply conditional formatting to any 3D object, as long as you base the formatting on a field that has numeric, color name or hex code, or web URL value. Conditional formatting support is added to the 3DBI visual version 2.4.

But first, what is 3DBI?

3DBI is a custom visual we created for Power BI that will allow you to bring various types of 3D models directly into Power BI. Typical industries making use of 3DBI are property management, facility management, warehouse management, building information management, or just about any industry where you deal with information about physical objects in a physical world. The following tutorials can provide more in depth information on how to create these models yourself:

New Feature – Multiselect in 3DBI

Control your selection. In this tutorial you will learn how to select multiple objects at once in your 3DBI models in Microsoft® Power BI®.  Multiselect support is added to the 3DBI visual version 2.5. To select multiple item in the 3DBI visual, you have to: Press and...

New Feature – Conditional Formatting in 3DBI

Conditional Formatting? In this tutorial you will learn how to add conditional formatting to your 3DBI models in Microsoft® Power BI®. With conditional formatting you can specify customized object colors, including color gradients, based on field values. You can apply...

How-To – 3D Real Estate dashboard in Power BI

Creating an interactive 3D real estate dashboard, in Power BI. In this tutorial you will learn how to bring your SketchUp model's geometry and topology information as well as external real estate information into Microsoft® Power BI® so that you can create interactive...

How-To – Add scenes to a 3DBI model with 3DBI for SketchUp

Scenes in 3DBI. Scenes are predefined camera positions. By adding scenes to your 3DBI model users can quickly navigate to predefined locations without having to manually manipule the camera. In this tutorial you will learn how to add scenes to your 3DBI model....

How-to – 3D quantity takeoff dashboard in Power BI

Creating an interactive 3D quantity take-off dashboard, in Power BI. In this tutorial you will learn how to bring your SketchUp model's geometry and quantity information into Microsoft® Power BI® so that you can create interactive 3D quantity takeoff dashboards. The...

How-To – Add scenes to a 3DBI model with 3DBI for Revit

Scenes in 3DBI. Scenes are predefined camera positions. By adding scenes to your 3DBI model users can quickly navigate to predefined locations without having to manually manipule the camera. In this tutorial you will learn how to add scenes to your 3DBI model....

How-To – Visualize a 3D Revit MEP model in Power BI

Custom 3D Power BI visual based on a Revit MEP model.

How-To – Custom 3D Power BI visual of Revit rooms with a static context

Custom 3D Power BI visual based on a Revit rooms.

How-To – Custom 3D Power BI visual of a warehouse

Custom 3D Power BI visual of a warehouse, modelled in SketchUp.

Getting started

To illustrate the purpose of conditional formatting we have created a 3DBI model of a warehousing containing roughly 30.000 bin locations. Also, our dataset contains a column that specifies per bin location what the fill rate is of that location, going from 0 to 100%. We will be using that field to colorize all objects with a gradient color.

1 – Default colors

3DBI models contain color information about each object. By default, it is that color that is given to all objects in the 3D view.

2 – Overwriting Colors

To indicaticate that you want to overwrite the default colors that come with the model, you must assign a category to the Color By field. Ideally that category should only contain 1 single entry because only 1 conditional color can be given to the 3DBI visual. In case you data does not contain a column with a static value for all rows you can create a new one in the Data tab in Power BI.

Right after assigning a value to the Color By field all colors in your model will be overwritten with a custom definable static color.

3 – Define gradients

The final step is to apply conditional formatting to the Data Color in the 3DBI visual’s property pane.

Et voila!

Every object in your 3D model will now receive a color that is calculated by Power BI, based on the conditions you defined.

More news

New Feature – Multiselect in 3DBI

New Feature – Multiselect in 3DBI

Control your selection. In this tutorial you will learn how to select multiple objects at once in your 3DBI models in Microsoft® Power BI®.  Multiselect support is added to the 3DBI visual version 2.5. To select multiple item in the 3DBI visual, you have to: Press and...

read more
Real 3D Digital Twins in Power BI, an experiment.

Real 3D Digital Twins in Power BI, an experiment.

2023 January 2023 to be more specific. 3DBI - our versatile 3D model viewer for Microsoft Power BI - has been released a few years ago, powering hundreds if not thousands of BIM, warehousing, logistics, facility management, mining, urban development, ... Power BI...

read more
How-To – 3D Real Estate dashboard in Power BI

How-To – 3D Real Estate dashboard in Power BI

Creating an interactive 3D real estate dashboard, in Power BI. In this tutorial you will learn how to bring your SketchUp model's geometry and topology information as well as external real estate information into Microsoft® Power BI® so that you can create interactive...

read more