CRMONCE

Creative

Conditional Formatting By Icons In Power BI

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

[rt_social_links]
Creative

Conditional Formatting By Data Bar In Power BI

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

[rt_social_links]
Creative

How To Do Data Cleaning In Power BI

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

[rt_social_links]
Creative

Add Index Column In Power BI Using Power Query Editor

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

[rt_social_links]
Creative

What Is Quick Measure In Power BI

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

[rt_social_links]
Creative

Power Query Features Related to Rows

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

[rt_social_links]
Creative

Create Report Manually in Power BI

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

[rt_social_links]
Creative

Create A Drill Through Button In Power BI

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

[rt_social_links]
Creative

Create A Power BI File Template For Different SharePoint Site

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

[rt_social_links]
Creative

Apply Conditional Formatting For A Text Column In Power BI

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

[rt_social_links]