Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
Solved! Go to 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
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
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.
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
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |