Category: Personal

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 trick or perhaps it’s not a trick 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.

Did you notice 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:

Revit Plan Region for Beginners

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

Revit Idea 02

Hi there! I hope you are well.

There is a great discussion here about one of my Revit Idea posts.

Check it out here and VOTE for it if you want it to happen in the future release of Revit software.

Grid Lines: Having the ability to control the top constraintsh

Have a great day.

Cheers,

Allan Cantos

BSc. Civil Engineering / Principal Structural Technician

Positive SSL