Archive for the ‘Power BI Desktop’ Category

PowerBI Syntax Highlight in Advance Editor

March 11, 2019 Leave a comment

This is a continuation of the post from last week.  Where I discovered by accident smart guides.  Next thing I discovered was Syntax Highlight.  Again another update — rather preview feature — I missed.

I tell customers to update their PowerBI Desktop frequently as Microsoft updates it monthly.  However, I get caught in daily grind and forget about my own updates.  So I miss important functionality that will make my life easier.

I was working on a function in Power Query Language (M Language) in advance editor.  However, I was running older version, so editing code was in single color (black).


Now most of the code for Power Query is written by Power BI (thank-god).  But if you had to do some custom coding, then you are on your own.  No syntax high-light, now brackets intelligent.  It got very frustrating when working on a more complex code.

So after turning on preview feature “M Intellisense”, now …


Again, I was jumping up and down.  Because I hated writing all black code.  I am a developer at heart.  And all Microsoft IDE have syntax high-light.  It was a big disappointment PowerBI did not have this.   Next thing that was disappointment in PowerQuery no intellisense.  Whoever heard of Microsoft products without, I was in hell.  Dam it!  Looking up references for each function was nightmare. This update made that pain go away! Yeeeh for preview features *bows*.


See, my PowerBI life is complete! Yes! Well until the next thing that gets me all happy :).


Power BI Smart Guides for Aligning Objects

March 5, 2019 Leave a comment

It seems all I am teaching for last year is PowerBI.  In my on journey to learn PowerBI development, one of the biggest things I hated was lack of alignment options in visualizations.

We have the align objects, when we select more the one visualization:

PBI Align Options

This is handy but it was still annoying because coming from other Microsoft products that have guides right on-screen for alignment, this was nice but was a big miss for me :(.

Next my pain was, if I want all the visuals to be the same size, now what?  There is no option for same size under format.

General Format

This was again handy but still annoying. Because doing this for each visual is painful.  To come over this I can use snap objects to grid, which helped a bit was not enough.   So when I discovered the guidelines I was in cloud 9 for a while (I am amused very easily these days :P).  I am very lazy in updating in my PowerBI Desktop, and I am further busy with reviewing all the updates released each month.  So I had completely missed this update from January 2019, Smart Guides!~  Discovered this while helping client build reports.

If you don’t have the newest version, I recommend updating it.  If you are running older than January look at preview options.  Anyhow, now when we move objects around we start seeing red-line to let me see the smart guidelines.  For bottom of object alignment, top of object alignment, center of an object, plus to help with sizing to make sure they are same size.

Center Align Smart Guide

Top Align Smart Guide

Bottom Align Smart Guide

PS. This is post for Jan 2019. I am a bit behind, goal was to get one post/month. So I hope to catch up for Feb post and Mar post before end of March :).

%d bloggers like this: