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 ...
Introduction : This article is about cleaning and transforming the data using the Power BI query editor. Power Query has many features that will help you clean and prepare your data for analysis. In this article, you will learn about the features related to rows. To open Power Query Editor...
Introduction : In this blog, I have explained how to create a report manually in Power BI. Click Create on the left side panel of the Power BI portal and Select paste or manually enter data option. On Click paste or manually enter data, and the below popup will be displayed. Add columns an...
Overview In this article, we will learn about one of the most important features in Power BI Desktop update which is – Drill Through as an Action for Power BI Buttons. This action type creates a button that drills through to a destination page to get details that are filtered to a specif...
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...
Upload all tables to the Power BI desktop to start the demonstration We have three tables named “ Mock_Data,sheet1,and sheet2 ” respectively. In Mock_Data Table, we do not have “Date” and “Sales” information, which is there in the other tw...
Introduction Here, I am using the ‘Append Queries’ feature in Power query editor to append two or more files located in different folders but have the same table structure. Data Details To append two files, I am having two excel sheet ‘Employee details’ and ‘Employee details1...