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.

“Photobucket” is not allowing 3rd party hosting on free accounts

Hello there. I trust you are having a great day.

Today I’ll talk about 3rd party image hosting. When I started building my Power BI dashboard, it looks cool to have images attached. The 3rd party image hosting website I’m talking about is “Photobucket”.

Please continue reading from here for more info: http://blog.photobucket.com/please-review-latest-changes-photobucket/

My Power BI dashboard really works well-having images on it that links interactively with your data until one time I received an email from “Photobucket” informing me that “third party hosting isn’t allowed” anymore on free accounts, you must pay $400 annual subscription in order for your image URL links to work. I just realized the effect of this when I opened my Power BI file to update the information on my dashboard.

Here is my previous Power BI dashboard I built last month.

Here it is now after 3rd party hosting is removed.

As you can see from the above image, my image URL link is now broken. To make it work, I need to find a place to store my images wherein it can provide me with a URL link. What I’ll do sometime next week is to remove all my images on Photobucket and since I do not have any intention to pay $400 annual subscription fee, I will also close my account.

As a replacement to “Photobucket”, I found a site called “ImgZeit”. Here is the welcome page when you visit the website  https://imgzeit.com/

I hope ImgZeit will give me free subscription by mentioning their site in this article, finger crossed (“,).

I only have 40 images stored on “Photobucket” as of this moment and therefore it does not cost me much of a headache. I imagine how infuriated those who have been using this website to store their images for their blogs that have been running for 2 years, 3 years or some maybe even more than 5 years.

I’m not in a rush to look for a free website to host my images. Anyone is free to recommend one if you know of any by leaving your comment below. Your feedback is highly appreciated. Thanks in advance.

Have a great day ahead.

Cheers.

Allan Cantos

#Revit_Tips_001

Hello there.

If you are one of those Technicians who is producing drawings from a reference view Revit models, this Revit topic is for you.

Now here is the situation, the project has 3 separate models; each one has its own Revit file.

Then there is a Revit file called “Sheet Model” where these 3 models are referenced in.

The views were generated by mimicking the levels of each building to the new “Sheet Model” Revit file and use these views to create the sheets shown below.

We managed to issue the drawings last March 2017 without any problem with the views and after that, because I got busy with another project, this project has been transferred to another Technician.

I got a call from this Technician asking for help wherein he was having a problem with a reference view of a general arrangement or plan view not appearing properly on his “Sheet Model” after doing some updates. He spent an hour trying to figure out how to fix the issue.

Here is the view we want to appear on the “Sheet Model” that he fixed at the “Sports Hall” Revit model.

And here it is when you are on the “Sheet Model”. The “green area” on the lower right-hand corner seems missing or might be a view range issue.

He looked at “View Range” and made it sure that the settings he has in “Sheet Model” Revit model matches the one he has in “Sports Hall” Revit model and both were the same.

So what could be the problem why the views are not the same considering that both models are now using the same “View Range” values?

Ok, here is the solution. If this view can’t be fixed by adjusting the “View Range” from the “Host View” (Sheet Model Revit model view range settings), then I will use the “Linked View” (Sports Hall Revit model view range settings) instead.

I started looking at the “Visibility Graphics” by clicking “Edit” or type “VG” on your keyboard.

Then go to the “Revit Links” tab and click on “Custom”

Look for the “View Range” and instead of “By host view”, select “By linked view”

 

Click “Apply” then “OK” and another “OK” and voila! Our view is now fixed!

Here is the view that my colleague wants to achieve on his “Sheet Model” Revit model.

I hope you’ll find this trick useful. If you think I can be of help on your project, don’t hesitate to drop me an email on my “Contacts” section. I welcome your feedback, comments, questions, corrections and additional information relating to this article. If you know a better way, please leave your comment; by all means, let me know. Thanks.

Have a great day!

Cheers,

Allan Cantos