To prepare for this recipe, perform the following steps:
- Open Power BI Desktop.
- 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 |