cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RichardJ
Resolver IV
Resolver IV

Best way to allocate stock to a kit - Formatting question about options

Hi,

I have parts produced in an spordaic sequence and these parts get grouped into Kits.

 

The Parts in the example are numbers Part 1, Part 2..... Part 10. 
A Kit comprises of one of each Part, so Part 1, Part 2..... Part 10 equals 1 Complete Kit.

 

Ive been attempting to create this view 

 

Desired viewDesired view

 

I can get a view of Parts available per Kit or

Parts available by Date

 

the challenge i'm having is getting the view above which shows that I may have produced two kits on a Monday called Kit 1 and Kit 2 and wondered if it's possible to surface them in a visual that shows both the Date and the kit numbers for that day.

The bottom table in the screengrab does this but it's not very aesthetic as it requires the user to expand the +.

 


ProgressProgress

 

I may be overthinking this - the exam question is to find and show the user the 'number of complete kits' produced on a specific day, and if there are any missing parts make it simple for the user to show which part(s) are missing from the kit.


The first available part(s) should be allocated to the first available kit slots that are short of the Part Number (this is what I was trying with the sub-index to get the allocated Kit Number for each Part Number).

If theres a simpler way of doing this, or if anyone can suggest a better approach please can you let me know.

The pbix can be found here.

 

https://www.dropbox.com/s/41sp7bt7d88ui0s/Allocating%20Stock%20to%20a%20kit%20question.pbix?dl=0

 

Thanks

1 ACCEPTED SOLUTION
RichardJ
Resolver IV
Resolver IV

Hi @v-zhangti - Thanks for taking the time to  respond and for pointing that out. I ended up using a different approach to resolve the issue.

View solution in original post

3 REPLIES 3
RichardJ
Resolver IV
Resolver IV

Hi @v-zhangti - Thanks for taking the time to  respond and for pointing that out. I ended up using a different approach to resolve the issue.

Hi, @RichardJ 

 

Can you share your own solution to help others find it?

 

Best Regards

v-zhangti
Community Support
Community Support

Hi, @RichardJ 

 

I found that the Date format in your file is text, do you need to convert to date format.

vzhangti_0-1669703167949.png

Wouldn't this be more in line with your desired outcome?

vzhangti_1-1669704534177.png

 

Best Regards,

Community Support Team _Charlotte

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.