Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I would like to have below two result with Power Bi .
(if you attached pbix file, it would be very good to me.)
Here is example with excel file.. (in case of the error, i update two link with same file)
1. I would like to have the defect rate (orange color... as below..
2. Drill down item.. for Years, 1st half & 2nd half year, Year Quarterly and Year Monthly. I need to use raw data that I have two table for the Defect table and Shippping table as raw data.. as below....
Thank you
Hi @redray82
Could you provide a clear calculation for defect rate?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |