Found 2044 Articles for Microsoft Technologies

X functions in Power BI

Aarti Kaushik
Updated on 03-Jan-2024 16:50:49

66 Views

Introduction Power BI uses the programming language known as DAX where analysts may resolve complex problems and deploy business constraints. The alternative name of the X function is the iterator function. Distinct types of X functions are SUMX, AVERAGEX, MINX, COUNTX, and MAXX and two parameters would be specified inside these functions. The first parameters specify a table, and the second parameter indicates the expression. In X functions, some specified actions are to be performed before aggregating the field values of a defined column. Let’s commence with a few examples − SUMX function in Power BI Step 1 Assume the ... Read More

How to develop a Slicer(new) to allow users to filter employees based on their job roles in Power BI?

Aarti Kaushik
Updated on 03-Jan-2024 16:49:57

46 Views

Introduction In this article, we will elucidate how to insert a Slicer(new) to filter employee data according to their job roles. The Visual format option may be chosen to develop a more interactive slicer where boundaries, font size, and font color can also be edited. Slicer is an alternative way of filtering. Numeric Value, Relative Date and time, and Hierarchy are the primary types of slicers. The benefits of slicers include easy access to filtered data, fast retrieval of employee-related information, column-based data filtering, vibrant reports, and compatibility with other charts. Filtration of employee names based on specific constraints through ... Read More

Create a simple clustered chart to show the Gender Distribution in the employee dataset

Aarti Kaushik
Updated on 03-Jan-2024 16:49:30

45 Views

Introduction Visualization is an effective technique where the users can showcase their data in the presentation form. Numerous built-in visuals are available in Power BI tools like Simple clustered charts, Line charts, Heat maps, Funnels, Gauge charts, Pie charts, and so on. Through these visuals, the segregation of data based on accuracy enables quicker identification of useful information while eliminating time-consuming manual corrections. We will examine the clustered chart in this article to observe how the gender distribution in the employee dataset is displayed. Creation of a simple clustered chart to show gender distribution in the dataset Step 1 ... Read More

How to Create a Waterfall Chart in Power BI?

Aarti Kaushik
Updated on 03-Jan-2024 16:48:44

42 Views

Introduction The waterfall chart denotes the increment or decrements in values that might change over time, as well as by year. Usually, the y-axis denotes a change in data values, and the x-axis denotes year, time, etc. For example, users can see the increment or decrease in net sales yearly through this chart. In the waterfall chart, the green color shows a hike in gross sales where blue color shows the total sales, and the red color demonstrates a decline in sales production. In this article, we will understand how to develop the Waterfall chart in Power BI. The ... Read More

How to create a Radial Gauge Chart in Power BI?

Aarti Kaushik
Updated on 03-Jan-2024 16:48:13

47 Views

Introduction Users can identify the critical areas of businesses after monitoring numerous KPIs and visualize them through radial gauge charts. It comprises of semi-circular arc representing a solitary value that slowly reaches a destination value. Users may set the smallest value, destination value, and largest value, add a specific field on the gauge chart, and develop a vibrant Gauge chart by employing conditional formatting. The present field value lies between the smallest and largest values on the Gauge chart. To develop a radial Gauge chart in Power BI Step 1 Consider the sample datasets named Sheet1(2) consisting of six columns ... Read More

How to create a Funnel Chart in Power BI?

Aarti Kaushik
Updated on 03-Jan-2024 16:47:37

48 Views

Introduction A funnel chart is used to show how data is gradually reduced as it moves from one phase to the next. The final stage represents the highest value whereas the primary stage denotes the smallest value. Each of these stages' data is shown as a different percentage of 100% (the total). Unlike cluster column charts, axes are not employed in the Funnel chart. For example, monthly sales production, identifying the employee’s salary range from maximum to minimum, and net revenue month-wise can be visualized through a Funnel chart. Shortlist the employee salaries through a Funnel Chart Step 1 Open ... Read More

Explain the concept of Report View, Data View, and Model View in Power BI

Aarti Kaushik
Updated on 03-Jan-2024 16:44:59

48 Views

Power BI is a good tool with three major views Report View, Data View, and Model View which we will discuss in this article. Power BI can be useful for an individual who wants to derive some useful insights from the data and permits users to visualize. In short, it can be defined as a tool used to connect different data sources, by transforming and modeling data, creating an interactive visual report, and sharing these reports with others. Power BI is developed to help organizations and individuals make data-driven decisions by turning raw data into actionable insights. The first window ... Read More

Generate a DAX measure to compute the average BMI for hypertension patients

Aarti Kaushik
Updated on 03-Jan-2024 16:46:36

44 Views

Introduction In today's era, youngsters and older adults are suffering from hypertension and diabetes due to excessive work pressure. Manually calculating the average BMI in an enormous dataset is time-consuming for data analysts. To overcome this problem, the DAX measure is an excellent way to evaluate the average BMI of hypertension patients and count the number of diabetes patients. The complex problem would also be resolved swiftly, and accurate results would be generated through the DAX function. We can follow these steps to create new measures in the Power BI desktop − Creation of a table in Microsoft ... Read More

How to compute the average monthly income for employees and illustrate it in a card visualization

Aarti Kaushik
Updated on 03-Jan-2024 15:39:19

43 Views

Introduction Power BI is an awesome tool for creating interactive reports and modeling data. Various built-in visuals are exclusive in the Visualization pane where measures, aggregation functions, and so on can be applied to construct the specific model. A card visual is one of the crucial visuals where a computed solitary value like average salary, maximum salary, or total production in a specific year is to be highlighted on a card. In this article, we will explore how to compute the average monthly income for employees and illustrate it in card visualization. Computation of Average Monthly Salary Step 1 You ... Read More

Advanced Filtering: How to create a Slicer in Power BI?

Aarti Kaushik
Updated on 03-Jan-2024 14:55:27

47 Views

Introduction Users may populate the selected employee data through the slicer on the dashboard. Two options Filter and Slicer assist users in filtering data. Slicers are more flexible and dynamic, provide quick accessibility of data, are easily embedded into the Report editor, and are also compatible with other charts. The disadvantage of slicers is that a Visual filter is not permitted in slicer visual, and choices like drill down, and input fields can’t be endorsed. In this article, we will learn the fundamental concepts of creating a slicer to shortlist the employees’ names based on age categories. To create a ... Read More

1 2 3 4 5 ... 205 Next
Advertisements