Power Bi chart like Pivot chart with more axis fields

[powermooc]

I'm new to Power Bi, followed most of the tutorial on MS but haven't figured yet how creat a graph that resembles this graphic I did with Excel - Pivot Chart, using as source the same data table.

What I need to recreate in Power Bi is a column graph with the most requested (pre-orders requests % of total sum) products in different price ranges.

Table ie.

| Date | Product | 3 to 5 Eur | 5 to 8 Eur | 8 to 11 Eur |
----------------------------------------------------------
| mar17| Coffe   |     12     |     7      |       2     |
| mar17| Milk    |     15     |     3      |       1     |
| mar17| Honey   |     17     |     0      |       5     |
| mar17| Sugar   |     20     |     9      |       8     |

Thank in advance for the help!

Bests,

A

[v-caliao-msft · Accepted solution]

@powermooc,

You need to unpivot your data. Select "3 to 5 Eur" column, "5 to 8 Eur" column and "8 to 11 Eur" column, click "Unpivot Colums"

Then you data looks like

Then create a chart like below.

Regards,

Charlie Liao