Forum Discussion
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
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-msftMicrosoft Employee
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