Overview of Hide and show pages in power bi: In this article, we will check how we can hide and show the pages in Power BI. Power BI recently released this new feature in the January update. This feature is very helpful for all developers. Sometimes, when a report is in the development pha...
Power Bi : 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 [&hel...
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...
Power BI: 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 will ...
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 ...
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...
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 ...