0
0
Power BIbi_tool~10 mins

Visual formatting options in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales data for three products

CellValue
A1Product
B1Sales
A2Apples
B2150
A3Bananas
B3200
A4Cherries
B4120
Formula Trace
FORMAT(B2, "Currency")
Step 1: B2
Step 2: FORMAT(150, "Currency")
Cell Reference Map
   A       B
1 Product  Sales
2 Apples   150  <-- referenced
3 Bananas  200
4 Cherries 120
The formula references cell B2 which contains the sales value for Apples
Result
   A       B
1 Product  Sales
2 Apples   $150.00
3 Bananas  200
4 Cherries 120
The sales value for Apples is shown formatted as currency with a dollar sign and two decimals
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the FORMAT function do in this example?
AAdds 150 to the sales total
BConverts the text "Apples" to uppercase
CChanges the number 150 to a currency string "$150.00"
DCalculates the sum of sales
Key Result
FORMAT(value, "format_string") converts a value to a formatted text string