Need Help

[sameergupta60]

How to create date wise chart using the below format.

The date column is repeated 18 May 20 to 28 May 20 is planned & from 18 May 20 to 28 May is actual column data.

Please guide us

Project	Contractor Name	Scope	Trade		18-May-20	19-May-20	20-May-20	21-May-20	22-May-20	23-May-20	24-May-20	25-May-20	26-May-20	27-May-20	28-May-20	18-May-20	19-May-20	20-May-20	21-May-20	22-May-20	23-May-20	24-May-20	25-May-20	26-May-20	27-May-20	28-May-20	29-May-20
B	X	Core & Shell	Carpenter	71.4	80	80	80	80	80	80	80	80	80	80	80	8	0	8	12	0	14	13	13	12	12	12	10
B	X	Core & Shell	Fitter	105.2	110	110	110	110	120	120	120	120	120	120	120	17	0	17	16	0	14	17	13	13	12	12	12
B	X	Core & Shell	Carpenter helper	52.9	60	60	60	60	60	60	60	60	60	60	60	8	0	8	15	0	12	11	12	11	10	10	8
B	X	Core & Shell	Fitter Helper	74.3	80	80	80	80	80	80	80	80	80	80	80	14	0	14	14	0	12	15	12	12	10	10	12
B	X	Core & Shell	Labours	39.0	40	40	40	40	40	40	40	40	40	40	40	11	0	14	11	0	7	9	14	5	4	9	6

[Anonymous]

@sameergupta60 

You cannot create chart with current table, the data should recorded in a form with date as a column. e.g.

Date	Value	Project
2021.1.1	23	A
2021.1.1	23	B
2020.1.2	21	A
2020.1.2	20	B
...	...	...

Then you can easily create chart by just dragging in columns. You may provide a pbix if need help on transform, this table doesn't not paste properly to my power bi desktop.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

can i first ask what you are actually trying to do with your data, what is your obective, wha tis the stroy you are wanting to tell?  Also what are the measures you are using, is it time? minutes?

[sameergupta60]

using scope & trade I want chart  date wise graph

[manikumar34]

@sameergupta60 , 

Can you share sample data set and with expected explained please?