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[…]
Combining multiple files from one folder is already supported built-in through the graphical interface of Power Query when use you Get Data from Folder. However, if you have one Excel file, with multiple sheets with the same structure but different data, you cannot use that option. There is a very little but useful trick that Read more about Combine Multiple or All Sheets from an Excel File into a Power BI solution Using Power Query Dynamically[…]
Despite the fact that I have explained about the Analyze in Excel feature in Power BI before, still, I hear and see many users are using the Export data option in Power BI much more. In this post, I am explaining what is the difference and why it is better to use Analyze in Excel Read more about Say No to Export Data, Yes to Analyze in Excel: Power BI and Excel Can Talk![…]
You don’t have always the luxury of having a snapshot fact table that has the stock on hand value for every single day, at every single workshop, and for every single product. Even if you want to build such a table, it can get easily gigantic. In this blog post, I am going to show Read more about Calculating Stock on Hand Using DAX: Power BI Inventory Model[…]