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[…]
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[…]
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[…]
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 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[…]
If you tried the option Publish to Web in Power BI recently, you might have seen the error saying “Contact Your Admin to Enable Embed Code Creation”. In this blog post, I am going to talk about why you see this error message, what is the reason behind it, and how to get it resolved. Read more about How to Resolve Publish to Web Error Message: Contact Your Admin to Enable Embed Code Creation[…]
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[…]
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[…]
In Power BI, there are multiple ways of searching for a text term inside a text field, you can use Power Query for doing this operation or calculations in DAX. In this post, I’ll explain some functions in DAX that you can use to do this calculation. Most of these functions can be used inside Read more about Find a Text Term in a Field in Power BI Using DAX Functions[…]
In the last blog an introduction to the Decomposition tree has been provided. In this blog, AI split of the decomposition tree will be explained. From last post, we find out how this visual is good to show the decomposition of the data based on different values. There is another split based on the how Read more about Decomposition Tree Visual in Power BI- Part Two[…]