Assign colors to objects in Vcad

Posted by Admin

Asset analysis, Bim, Colors, Custom visual, Data visualization, Microsoft, Power BI, Template, Vcad

22 September 2020

In this article we show you the procedure for creating and assigning colors to objects by entity.
We used the ASSET AND SPACES COLOR template where you may find a color table and a function to populate the color column quickly. The procedure is the same if you want to assign a personalized color to the spaces or based on different characteristics.

Add Color Table – step by step

1) Open the Power Query Editor, select the table and the column you want to take the attribute from, right-click on the header and then ‘Add as New Query’.

2) Right-click on the header, select ‘To Table’ and then ‘Remove Duplicates’.

3) Select the ‘Add Column’ and ‘Index Column’ tab to add an Index field.

4) Use ‘Invoke Custom Function’ to call function ‘color’ and select index = Value.

5) The end result is a lookup table with colors that can be merged with the main table and a relationship can be created with the table that contains the attributes.

6) Use Table Visual and select SpaceName and SpaceNameColor fields.

7) Right click SpaceNameColor, ‘Conditional formatting’ and ‘Background color’ and ‘Font color’.

8) Select ‘Format By’ = ‘Field Value’.

9) Select Vcad custom visual and add SpaceNameColor to ‘Highlight Color’ Field to enable theme selection.

Please watch the video below, it contains a detailed explanation of all the operations to be done.


You May Also Like…


Blogic s.r.l.
via F. Mengotti, 15
00191 Rome (RM) Italy
P.Iva 05731610720


Try it now for free!


Try it now for free!


If you want to be updated on future Vcad developments please follow us on