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...
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...