Power BI Assignment-3

#assignment #-3 #4 #5

yashvi Rupwani Apr 08 2021 · 1 min read
Share this

The Steps involved are as given below:

Get Data -> Excel -> Navigate to Directory -> Select Wealthy.xlsx and Open

Check Billionaires and click on Transform Data

Changed the Data Type of Age

Rename the columns by double-clicking

Step 1

Transform -> Replace Values -> Replace Values -> Value to Find - billion -> Replace with - keep the cell blank -> OK

Step 1

Transform -> Replace Values -> Replace Values -> Value to Find - billion -> Replace with - keep the cell blank -> OK

Home -> Close & Apply -> Apply -> Close

Creating a visualization to Prove

Create a chart just to prove that the billions really are being treated as numbers.

Create a Clustered Column Chart

In the Fields section Drag Name to Axis and to Billions ($) Values

Go to the Format section

In X axis change the font in the Font Family Option

Turn Off Y axis

In Data color change the color of the graph

In Data labels change the font in the Font Family Option

In Title section:

Enter the title text

Align the title to centre

In Background section, Change the Color

Turn the Border On

Turn Shadow On and change Shadow position to Inside

Comments
Read next