The Power Query Editor in Power BI is a strong tool for transforming data. It helps you clean and manipulate data right within Microsoft Power BI. In this tutorial, I will explain how to create table in power query, including: Power Query Create Table To create a table in power query, follow the steps below: … read more…
One of my subscribers emailed me recently. When they tried to publish their report on the web, they got an error message saying, “This content isn’t available. Learn more about Power BI.“ In this Power BI tutorial, we’ll talk about how to fix an error message that says, “This content isn’t available.” Power BI Error: … read more…
The Power BI Pie chart has one drawback. We can not find any conditional formatting option because it is unavailable in the chart. However, we have an alternative way to apply conditional formatting to the Power BI Pie chart. In this tutorial, I will explain how to apply conditional formatting in Power BI pie chart … read more…
Pie charts in Power BI are typically used to represent the composition or distribution of a single categorical variable in your data. In other words, we would use a pie chart when we want to show how parts of a whole relate to each other. In this tutorial, we’ll learn how to create a Pie … read more…
In Power BI, you can use the IF function in two ways: with the DAX function and in the Power Query editor. In this tutorial, I will explain Power BI IF statement, how to use if statements in Power BI and Power BI if statements with text. Also, we will see the topics below: IF … read more…
Power BI offers many built-in charts to visualize data; creating them is easy with just a few clicks. Among these charts, the Power BI line chart is great for showing data trends over time. In this tutorial, I will explain line charts in Power BI and how to create a line chart in Power BI … read more…
I encountered an interesting requirement last week when working with a client. They wanted to automate a process based on the day of the week in Power Automate. Precisely, they needed to trigger different actions depending on whether it was a weekday or a weekend. Luckily, Power Automate provides built-in functions that make it easy … read more…
As a Power Apps app developer, you will often be required to use the count() function in Power Apps. So, you should know how to use the Power Apps count() function. In this tutorial, I will explain how to use count() in Power Apps with some real examples. Many related count functions are available, such … read more…
A few weeks ago, I encountered an interesting scenario while working with strings in Power Automate. That’s when I thought sharing how to handle different string conditions in Power Automate would be helpful. In this article, we’ll explore Power Automate Condition If String, such as checking if a string is empty, verifying if it contains … read more…
