Category: Power BI

Merge Data Tables Easily in Power BI and Power Query using Include Relationship Columns Feature

Posted on by Reza Rad

Power Query gives you the capability of joining (merging) tables together using key columns, and there are multiple types of Merge types to choose from. There is another way to merge tables especially when the data source is a relational database system. In this article and video, You will learn how this options works. Video Read more about Merge Data Tables Easily in Power BI and Power Query using Include Relationship Columns Feature[…]

Bookmarks and Buttons: Making Power BI Charts Even More Interactive

Posted on by Reza Rad

In the previous post, I explained a usage of bookmarks and buttons in Power BI, which was for clearing all slicers. Buttons and bookmarks are the gold combination in Power BI. You can do wide range of creative activities with this combination. In this post, I will show you some other usages of buttons and Read more about Bookmarks and Buttons: Making Power BI Charts Even More Interactive[…]

Bring to Front or Send to Back in Power BI

Posted on by Reza Rad

When you have multiple items overlapping, you often need the feature to bring one forward or move it backward. In Power BI, this feature isn’t available by right-click. Instead, there is a Selection pane where you can easily set the order of elements. The selection pane also has other benefits. In this article and video, Read more about Bring to Front or Send to Back in Power BI[…]

Grouping and Binning; Step Towards Better Data Visualization

Posted on by Reza Rad

The latest update of Power BI Desktop (October 2016) has many features. Two of these features are grouping and binning. These features used to create groups of items and visualize them better in the report. Previously you could do that by Power Query or DAX calculated columns, now it is all possible simply through the Read more about Grouping and Binning; Step Towards Better Data Visualization[…]

Storytelling with Power BI Scatter Chart

Posted on by Reza Rad

Column or Bar chart can be easily used for showing a single measure’s insight across a category. Mixed charts such as Line and Column chart can be used for showing two measure and comparing their values across a set of categories. However there are some charts that can be used to show values of three Read more about Storytelling with Power BI Scatter Chart[…]

What Fields to Hide in Your Power BI Solution?

Posted on by Reza Rad

To tidy up your Power BI solution, there are some options, and one of them is hiding fields from the report view. This option, although simple, has a significant impact on making your Power BI solution very tidy and clean and easier to maintain. However, you might wonder what are fields that have to be Read more about What Fields to Hide in Your Power BI Solution?[…]

Power BI Model Analysis using DAX INFO Functions

Posted on by Reza Rad

There are many DAX functions for covering day-to-day business-related calculations using measures and calculated columns. However, there is also a set of functions that can be helpful to the BI team and developers in gaining insights from the Power BI model itself. The insights can include things such as the number of both-directional relationships, the Read more about Power BI Model Analysis using DAX INFO Functions[…]

Medallion Architecture in Fabric: Why? What? and How?

Posted on by Reza Rad

You must have heard the buzzword “Medallion architecture.” if you are working in the data space, and have listened to a lot of other misconceptions with it, such as Medallion architecture is different than Microsoft Fabric, or Microsoft Fabric is similar to the medallion architecture, or even things such as we don’t use medallion architecture Read more about Medallion Architecture in Fabric: Why? What? and How?[…]

Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold

Posted on by Reza Rad

Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer to this question is yes, then this feature is built for you. Let’s explore in details how the fuzzy matching works in Power BI. To learn more about Power BI, read Read more about Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold[…]

Find Mismatch Rows with Power Query in Power BI

Posted on by Reza Rad

Finding rows that are in one table, but not the other is one of the most common scenarios happening in any data related applications. You may have customer records coming from two sources, and want to find data rows that exist in one, but not the other. In Power Query, you can use Merge to Read more about Find Mismatch Rows with Power Query in Power BI[…]