Power BI Tricks

Hello there, Allan Cantos here. Apologies if I’ve been so quiet last month as lots of things happened in my personal life, however, nothing to worry, all were good ones.

Today, I’d like to share to you a tricks or perhaps it’s not a rick but rather a remedy if you happen to encounter the same issue I encountered while working with Power BI.

I was working in Power BI Desktop finalizing my dashboard before publishing it and when I am ready to publish it, to my surprise, the “Multi-row card Title” filter that I applied didn’t show up in the published version.

You noticed the difference between the two versions in the yellow green background cards?

I did some test and found a solution and I am more than happy to share this with you. We all learn from each other anyway. If you happen to have other solutions to the problem I encountered, please do share it by adding your comments below.

Ok, here’s what I did. First I turn-off the “Title” filter of my Multi-row card.

Next, I published my dashboard and replace the dataset.

After that, I went back to my Power BI desktop and turn-back-on the
“Title” filter of my Multi-row card. Publish again and replace the dataset and your published version will now be the same as the one you have in Power BI Desktop.

Next time, I’m going to teach you how to duplicate your page and use your next data for the next stage without breaking the link to the selection filter.

As before, if you find it helpful, don’t forget to leave a comment. Thanks and have a great day.

Cheers.

How to view missing architectural 2D detail line furniture in Revit.

Hi there, I hope you are well.

Apologies for not being able to write something in the past few weeks for being to occupied with lots of things.

Without further a do, here is my scenario. I need to update the extents of my area loading plan hatches, however, upon reloading the latest architectural model (Building F), all I can see are the partition walls and doors and without the furniture. I have 2 building side by side, Building E and Building F. On the adjacent building, Building E, I can see the furniture.

You can see from the image below that it will require some updates. It would be very helpful if you can see the furniture for you to know where exactly the bathroom (hatched in red) are located, for instance.

I opened the architect Revit model to check if they have the furniture layout, and yes, they have it in their model under a separate workset.

I checked my “View Template” view properties one by one and all looks good to me.

I checked the “View Range” and it also looks fine to me.

If you’re wondering why I set my “View Depth” to just 200 below my associated level is because I don’t want to see the partition walls below. All I wanted to see are the partition walls on the floor I’m looking at.

If I set the “View Depth” way below the slab soffit, say -1200, the result is, you’ll be able to see the wall partitions from the level below (making the floor plan looks complicated).

Now, I remember something and that is, for instance at Level 10, Level 10 of Building E is not the same as the Level 10 of Building F. My “View Range” associated level is from Building E. Building F Level 10 is below Building E Level 10 by 575mm.

So, in order for me to see the furniture from Building F, I need to add a plan region (hidden line in magenta from the image below) in order for me to set a view range specific to Building F.

For some of you who are not familiar with “Plan Region”, I’ve written an article about this topic which you can find from visiting the link below:

After adding the “Plan Region”, I can now set my “View Depth” making it sure that my depth is within the thickness of my concrete slab floor (225mm thick concrete slab).

Click “Apply” and “Ok”. I should now be able to see my furniture layout.

For beginners in Revit, I hope you find this helpful.

Cheers,

Allan Cantos

BSc. Civil Engineering / Principal Structural Technician

Building Information Modelling Newly Released Standards

Hi there. I hope you are all well.

I am sure you are all aware that there are newly released standards to replace BS1192:2007 and PAS 1192-2:2013. I should have written this article when the new standard was released, but I was so busy with lots of things and couldn’t find a time to sit, think and write something for my blog.

Effective 16th of January this year, the British Standards (BS) 1192:2007 and Publicly Available Specifications (PAS) 1192-2:2013 will be withdrawn and to be superseded by BS EN ISO 19650.

BS EN ISO 19650-1: Organization and digitization of information about buildings and civil engineering works, including building information modelling — Information management using building information modelling: Concepts and principles.

BS EN ISO 19650-2: Organization and digitization of information about buildings and civil engineering works, including building information modelling — Information management using building information modelling: Delivery phase of the assets.

For more information and how to get a copy of the other available standards used for Building Information Modelling (BIM), please visit https://bim-level2.org/en/standards/

I don’t have a copy of these standards yet and therefore I could not provide you with any further information about its content.

Have a great day.

Cheers.