Creating multiple lines in graph based on one column in table

Question

Hi,I have a table, similar to the one below with locations, dates, and amounts all in one table.LocationDateChairs soldLamps soldCushions sold11/12/20211005121/12/202120010231/12/202130030341/12/202140050512/12/202120030522/12/202130020332/12/202140051042/12/202150010213/12/2021030423/12/20215052333/12/202130014543/12/2021500211&nbsp;I'd like to make graphs similar to the one below, where each location is a separate line showing sales over time:&nbsp;Any advice on how to set this up would be apprciated - I'm fairly new to this, but enjoying the learning journey!

amitchandak · Accepted Answer

benh66 , Date on axis, Location legend and sum of Chairs sold is on values

Forum Discussion

Creating multiple lines in graph based on one column in table

2 Replies

Related content

Create columns group

Create custom column based on multiple rows

Sequential Order column based on multiple criteria

Creating multiple Audiences in PowerBI App

Multiple line and clustered columns chart

Location	Date	Chairs sold	Lamps sold	Cushions sold
1	1/12/2021	100	5	1
2	1/12/2021	200	10	2
3	1/12/2021	300	30	3
4	1/12/2021	400	50	5
1	2/12/2021	200	30	5
2	2/12/2021	300	20	3
3	2/12/2021	400	5	10
4	2/12/2021	500	10	2
1	3/12/2021	0	30	4
2	3/12/2021	50	52	3
3	3/12/2021	300	14	5
4	3/12/2021	500	21	1