Data & Intelligence

Tips and Tricks in power BI desktop

Data is the lifeblood of modern businesses, and we’re generating more of it than ever. But amassing mountains of digital information isn’t much use unless organizations are able to make sense of it. That’s where business intelligence software comes in. Microsoft Power BI is data and analytics reporting tool that helps organizations bring together disparate data sets into reporting dashboards.

Let’s Dive into some of the Amazing Tips and Tricks in power Bi

  1. Aligning the Objects

Dragging a visualization around the page will reveal the quick alignment lines.  These red, dashed lines are a great way to align one visualization with another. These works well when you have few items to align. but what if you have many items for alignment?

In that situation, just press CTRL on keyboard and select the item you want to align. Now select the Format tab on header – Align- select the desired alignment

Pic1

Pic2

2.Organising the Measure– we can store the measure in any table in the model. But having Measures scattered across multiple tables can be like having an itch you can’t scratch. To solve the problem, create the dummy table, named it as measure table. every time when you want to create new measure just select table and right click -new measure, so all your created measures will be in same Measure Table.

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

Picture3

3.Lock the Object – It’s a sad day when someone kicks over your sandcastle. After spending hours designing the perfect report.  feel bad when end user moved your visuals. This is usually unintentional, but the damage done is the same. We can avoid this by freezing the position for some or all the visuals in report. select a visualization (or press CTRL-A to select all visualizations on the page), then click View (tab) -> Page Options (group) -> Lock Objects. This should become a step you perform towards the end of EVERY report your build.

 

Picture4

  1.  Formatting DAX – formatting your DAX expression is most important thing to do, so that end user can also understand it by glance. no worries DAX FORMATTER is there for us. DAX Formatter is a free tool by SQLBI that transform your raw DAX formulas into clean, beautiful, and readable code. Just search for DAX formatter on google. paste your code and it will format your code in a second.

Picture5

  1. Useful Keyboard shortcuts for DAX editor

 Add lines: Shift + Enter

Insert cursor: Alt + Click

Move line up / down: Alt + Up arrow key/ Down arrow key

Copy line up / down: Shift + Alt + Up arrow key/ Down arrow key

Insert line below: Ctrl + Enter

Insert line above: Ctrl + Shift + Enter

Thoughts on “Tips and Tricks in power BI desktop”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Vaibhav Punwatkar

Vaibhav Punwatkar is a Senior Technical Consultant at Perficient. He is a Power BI developer and Power BI service Consultant. Vaibhav is excited to share his knowledge about Power BI and is open to suggestions from readers.

More from this Author

Follow Us
TwitterLinkedinFacebookYoutubeInstagram