Introduction : We can perform many tasks through a power query. One of the most popular tasks that we can perform in a power query is ‘removing unnecessary rows’. Here in this article, I going to show you how to remove unwanted rows. Step 1 – Remove from Top In the first step I a...
Power Bi Introduction : In this article, you will learn how to create a button and how to use it in Power BI reports. In a Power BI report, you can add different types of buttons. I am going to create a report using the ‘Employees’ table and ‘personal’ table. I have already importe...
Introduction : Conditional formatting is a feature in Power BI and Excel that enables us to use gradient colors to define customized cell colors based on cell values, other values, or fields. A new ‘Icon’ feature is available for conditional formatting in Power BI. In this article you ...
Introduction : In this article I will show you how to perform conditional formatting by data bars. You can represent cell values with data bars. Reports with Data bar are easy to understand by someone who doesn’t even know much about the Power Bi tool. Below are the steps for conditional...
Introduction : In this article, I will talk about why data cleaning is required and how to perform that operation like, Transform the Data Data Formating Set Header as the first row Replace value (or correction of data) Let us start In simple words, whenever the executive needs to presen...
Introduction : Power BI has a feature of adding ‘Index Column’ using power query editor. Through power query editor. Let’s start. Step 1 : First you need to open the Power query editor to click on ‘Transform Data’. I am adding ‘Excel sheet’ Add a new source into it. Step ...
Introduction : Quick measure is a powerful feature used to perform calculations easily and quickly. Quick measure contains a set of DAX queries that runs in the background and the result will show in your report. So, you don’t need to write any DAX query in Power Bi. When you create ...
A Power BI File Template We have the following two site collections with the same structure of the List data. I have a list named “R1” in my first site collection which is “VamsiDemo”. I have a list named “R1” in my second site collection which is “Surendra”. Assume that ...
Overview In this article, we will talk about how we can apply conditional formatting for A Text column in Power BI. Data fields We need the end result to be something like what is shown in the below screenshot. Step-1: Load the data from the data source into the Power [&hell...
Data Source Settings This can be used to change the data source for the same source type. You can change the data source using data source settings in two ways: Using File Using Transform Data Using File: The following steps outline the process of changing the data source for an existing r...