How to create a BIM dashboard in less than 10 minutes with Microsoft Power BI ? ๐Ÿ’จ

BIM Dashboard in 10 minutes
Written by Julian
๎‚Œ
Cases studies
๎ฅ
0 comment(s)
๎€ฃ
May 6, 2022
๏ฎ

Home ยป Cases studies ยป How to create a BIM dashboard in less than 10 minutes with Microsoft Power BI ? ๐Ÿ’จ

Before starting your BIM dashboard? ๐ŸŽฌ

  • Create your account on SeveUp app. You will have a 14-day free trial and no credit card is required to create an account. Follow this link ๐Ÿ”—
  • Create your first project . The “how-to” video is here
  • Load your BIM model. The “how to” video is here
  • Wait for processing …
  • Select your BIM models and after select your power bi template. The “how-to” video is here
  • For this example, we will choose the “blank” template
  • Open it on power Bi desktop. If you do not already have power BI installed on your computer, you can download it here. You can also follow this video to assist you in installing Power BI desktop.

You have just downloaded and opened a power Bi template file with the following extension .pbit. In order to work on your dashboard, I encourage you to save the dashboard in project mode ( extension .pbix)

  • Click on “file”
  • Save as
  • choose extension . pbix

Now, we are ready start , You must have the following window open

NOTE : If the table (see the table list on the left) “AssetTreeSpatial” is missing , you can find this article to add it.

Add a slicer to create your object class tree

  • Click on slicer in the visual bar to add in your dashboard

Move your slicer visual to a correct position inside your dashboard. You can also re-size it

Drag and drop the correct data inside your Slicer visual ( here column Class from Assets table

Add a pie chart to sort objects per level (storey)

  • Click on the Pie chart on the list of visuals that you will find on the right
  • Move and re-size the pie chart visual

Drag and drop IfcBuildingStorey column ( from AssetTreeSpatial table) inside the correct Pie chart fields ( Legend and Values)

Undisplay the title of the visual

Add a table to add Assets informations and calculation

Add a table visual, move and resize it

Drag and drop AssetId and ObjectType column from Assets table to the table visual (optional: select IfcDoor in the first slicer)

Add a calculation (Count distinct) on AssetId column

Add an other table for Quantity Take Off name value

Add a new table , move and resize it

Drag and drop name from Qto table

Add an advance card visual to display the number of assets selected

Drag and drop AssetId (in Data field of the advance card) from Assets table

Uncheck Category label in ” Format your visual” from the advance card

Change Display Units ( Data label section) in ” Format your visual” from the advance card

Add an advance card visual to display the value of the selected quantity

Drag and drop Value from Qto table

Uncheck category Label in ” Format your visual” from the advance card

Change Display Units and Value Decimal places (Data label section) in ” Format your visual” from the advance card

Turn Title to on and near the text zone , click on “fx” button

Format style = Field value. Chosse the parameter Name from QTO table

What field should we base this on ? = First Name and Summarization = First and click on OK

Activate the ” Postfix Label”

In the Postfix field , drag and drop Unit from Qto table

Exemple : Calculate the global Area of doors in the level 2 ( and display it in The 3D viewer)

Note: If you want more detail on How customized the BIM Viewer 3D SeveUp custom visual for Power BI desktop, you have a specific post on our blog for that

if you liked this article, then please subscribe to our Youtube channel for video tutorials. You can also find us on Linked-in.

0 Comments

Share