How to make a weight progress dashboard?

[visheshsaxena1]

I am trying to make a weight progress dashboard for a project.

Every month I get data in form of excel file like below. Every file has hundereds of such items. Every time the file comes with a new Revision number like C1, C2, C3 & so on

Item	Revision	Group	Discipline	Basic Weight	Net weight	Allowance	VCG(m)
Item1	C1	Group1	Discipline A	80	85	7%	5
Item2	C1	Group2	Discipline B	90	95	6%	6
Item3	C1	Group3	Discipline C	100	105	5%	7

I want to keep a track of total weight vs revison, VCG vs revision, Item X vs revison etc. in charts. 

I have saved all revisons in one excel file in separate tabs but can't think of a way to plot these type of charts w.r.t revisions. Can some one please sugguest a way ?

[v-mengzhu-msft]

Hi @visheshsaxena1 ,

If this what you want ?

When the revision is 1, the corresponding weight, VCG, and Item X values are displayed, as are the other revisions.

If I misunderstand your meaning ,please let me know in time.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[visheshsaxena1]

Hi @v-mengzhu-msft ,

Thanks for the reply.

I am looking for something like this:

Another thing is that I have seperate excel sheets for Revision C1, C2, C3 and so on and I am trying to find a way using which I can plot such charts using different tables in PowerBI.

[v-mengzhu-msft · Accepted solution]

Hi @visheshsaxena1 ,

Like this?

The inconsistency of the data, I can not do exactly what you expect, you can refer me to this practice:

1.modify the data:

2.put the slicer and line chart, as the above image shows.

refer to my pbix file for better understanding.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly