Getting ready

To prepare for this recipe, perform the following steps:

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

Item

Category1

Category2

Value

Item 1

Green

Blue

100

Item 2

Blue

Green

200

Item 3

Green

Blue

300

Item 4

Blue

Green

400

Item 5

Red

Blue

500

Item 6

Red

Green

600

Item 7

Red

Blue

700

Item 8

Red

Green

800