Transposing a data set is ultimately rotating data from rows to columns, or from columns to rows. To understand this concept, an…
Power BI is a self-service BI analytics and visualization tool. As the business data is increasing, it is becoming impossible for tools…
In this article, we will discuss the Doughnut Chart in Power BI. A doughnut chart is the same as a Pie chart…
In this article let us understand the Bar & Column Charts in Power BI visualization. One of the most common ways of…
MSBI is an abbreviated form of Microsoft Business Intelligence. To understand MSBI, it is important to understand BI (Business Intelligence) first. Here…
Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware…
As explained in the above example, we have generated a conditional column for the given query. If we want to split this…
One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s take…
Power Query helps you to perform a series of steps to modify your data. One of the steps is to split a…
Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst…
To do Power BI DAX deduplication based on column or to eliminate the duplicate data from a data set, Power BI has…
There is one more interesting feature of Power Query where it lets you add an index column that serves as a row…
You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have…
Normally data is viewed in the Unicode Font for any kind of data. But do you know you can also change this…
You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’ and end with ‘*/’. Comment…
Learn How to do Comments in Query Steps with Power Query. The new feature of Power Query allows you to add descriptions…
Power Query also allows you to create a list query from a data table available. The column from the given data table…
Learn How to Manage Parameters in Power Query Step-by-Step. [toc] Power Query can create a query parameter and link it to the…
One of the important and most needed features of Power Query is the Renaming Column Headers. Many people facing issues to rename…