Getting ready

To prepare for this recipe, do the following:

  1. Open Power BI Desktop.
  2. Use an Enter Data query to create a table called R06_Table that contains the following data:

Col A

Col B

Value

A

a

5

A

b

6

B

a

-4

B

b

3

C

a

-9

C

b

0

C

c

14

D

d

5

E

e

5

F

f

5

G

g

5

H

h

5

I

i

5

J

j

5

K

k

5

L

l

5