Count of Unique Values (DistinctCount) in Power BI Through Power Query Group By Transformation

Posted on February 27, 2020February 27, 2020 by Reza Rad

You can have a distinct count calculation in multiple places in Power BI, through DAX code, using the Visual’s aggregation on a field, or even in Power Query. If you are doing the distinct count in Power Query as part of a group by operation, however, the existing distinct count is for all columns in Read more about Count of Unique Values (DistinctCount) in Power BI Through Power Query Group By Transformation[…]

Customers Grouped by the Count of their Orders – Dynamic Segmentation in Power BI Using DAX Measures

Posted on February 25, 2020February 25, 2020 by Reza Rad

In the previous part of this article, I explained what is the segmentation challenge, when you want to group data based on the aggregated result, and I explained a static method of creating aggregated tables and creating a relationship to the main detailed table. However, the caveat of that method is the segmentation is done Read more about Customers Grouped by the Count of their Orders – Dynamic Segmentation in Power BI Using DAX Measures[…]

Customers Grouped by Count of Their Orders – Static Segmentation in Power BI

Posted on February 24, 2020February 26, 2020 by Reza Rad

One of the interesting calculation challenges in BI systems is a segmentation or grouping on a numeric value, based on an occurrence of another value. As an example; You might want to know How many customers ordered once, twice, three times or more. The challenge is that the data in the transactional table is not Read more about Customers Grouped by Count of Their Orders – Static Segmentation in Power BI[…]

The READ-ONLY License for Power BI

Posted on February 14, 2020February 25, 2020 by Reza Rad

In most of my presentations all around the world, I still get this question often: “Is there a Read-Only license for Power BI?”, and often starts with “I have some end-users, who are not building any reports, I don’t want to pay for Developer License for them”. I have written about Licensing in Power BI Read more about The READ-ONLY License for Power BI[…]

Be Careful When Merging on Text Fields in Power BI Using Power Query

Posted on February 12, 2020February 12, 2020 by Reza Rad

Merging two tables in Power Query is one of the most useful transformations to combine data from different datasets, and also create a flatten data structure. However, if you use a text field for merge, then you might see some unexpected results. Here in this post, I share some important considerations if you are using Read more about Be Careful When Merging on Text Fields in Power BI Using Power Query[…]

Change The Font Size or Color Across All Visuals and Pages in a Power BI File

Posted on February 11, 2020February 11, 2020 by Reza Rad

You can change the font size of a visual easily by going to the format option of that. However, if you want to change it for multiple visuals, better to use Themes for it. Recently Power BI Desktop came up with some easy-to-use options to customize your theme. That means you can now easily increase Read more about Change The Font Size or Color Across All Visuals and Pages in a Power BI File[…]

Customer Retention in Power BI: DAX Measures

Posted on February 10, 2020February 10, 2020 by Reza Rad

Customer retention is one of the most common scenarios of data analysis, which is very useful for business. As a business, you would like to know how many new customers you have in each month, how many returning, and how many lost customers. Knowing these, would help you to focus on the growth plan, and Read more about Customer Retention in Power BI: DAX Measures[…]

Move Measures to Another Table in Power BI

Posted on February 8, 2020February 8, 2020 by Reza Rad

The ability to move measures from one table to another table exists in Power BI, However, the process is not familiar for many users. Through my consulting and training work I have explained it to many of my clients. The process is simple and much better than re-creating the measure again and deleting the old Read more about Move Measures to Another Table in Power BI[…]

Replace BLANK with Zero in Power BI Visuals Such as Card

Posted on February 5, 2020February 5, 2020 by Reza Rad

If you use a field in a visual and based on a combination of slicer selection, that field doesn’t have any value, you might see blank in the visual. If you want to replace that blank to zero, here is a trick for you. a very simple trick that you can use anywhere easily. Sample Read more about Replace BLANK with Zero in Power BI Visuals Such as Card[…]