Forum Discussion

powermooc's avatar
powermooc
New Member
8 years ago
Solved

Power Bi chart like Pivot chart with more axis fields

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

  • 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

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee

    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