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