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

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

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[…]

How to Resolve Publish to Web Error Message: Contact Your Admin to Enable Embed Code Creation

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[…]

Move Measures to Another Table in Power BI

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

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[…]

Find a Text Term in a Field in Power BI Using DAX Functions

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[…]

Decomposition Tree Visual in Power BI- Part Two

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[…]

Combine Multiple or All Sheets from an Excel File into a Power BI solution Using Power Query Dynamically

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[…]

Say No to Export Data, Yes to Analyze in Excel: Power BI and Excel Can Talk!

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![…]

Analyse the JSON File with Power Query

In the last Post, I will explain how to analyze a JSON file that has been generated in the Sentiment Analysis process . some explanation, this is a JSON file that contains the sentiment analysis for the comments one traveler put on the hotel website as below The suite was awesome. We did not have Read more about Analyse the JSON File with Power Query[…]