Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am back again with another hurdle, I am using a Matrix visual for my order management/view, I am attempting to filter a second level row dynamically based on a specific due date on the top level item.
My source data `Incoming Orders`
Item Receive Date Model PO# Quantity 01077 9/27/2017 00042 PO84 -65 03254 9/27/2017 03844 PO47 -3 01077 10/2/2017 00042 PO84 -165 03670 10/5/2017 01095 PO13 -8 01006 10/9/2017 01036 PO69 -11.43 04640 10/10/2017 04067 PO66 -250 01717 10/12/2017 02882 PO41 -116.12 69388 10/12/2017 04066 PO35 -17 01761 10/12/2017 04071 PO58 -3.72 69388 10/17/2017 04066 PO35 -57 01112 10/17/2017 04068 PO24 -14.91 01205 10/19/2017 01149 PO82 -170 00779 10/19/2017 02961 PO15 -85 00064 10/19/2017 03302 PO19 -7 00861 10/19/2017 03302 PO19 -7 02882 10/19/2017 03844 PO47 -13 03254 10/19/2017 03844 PO47 -20 03843 10/19/2017 03844 PO47 -1 04183 10/25/2017 04182 PO84 -2 04189 10/25/2017 04182 PO84 -3 39269 10/25/2017 04182 PO84 -3 39270 10/25/2017 04182 PO84 -3 00064 11/1/2017 03302 PO19 -9 00064 11/1/2017 03302 PO19 -10 00861 11/1/2017 03302 PO19 -9 00861 11/1/2017 03302 PO19 -10
The current matrix display
Order Model Item Due Date OR8675309 00042 01077 10/16/2017 0:00 OR8675309 00042 01077 10/16/2017 0:00 OR8675309 01036 01006 10/16/2017 0:00 OR8675309 01095 03670 10/16/2017 0:00 OR8675309 01149 01205 10/16/2017 0:00 OR8675309 02882 01717 10/16/2017 0:00 OR8675309 02961 00779 10/16/2017 0:00 OR8675309 03302 00064 10/16/2017 0:00 OR8675309 03302 00861 10/16/2017 0:00 OR8675309 03302 00064 10/16/2017 0:00 OR8675309 03302 00064 10/16/2017 0:00 OR8675309 03302 00861 10/16/2017 0:00 OR8675309 03302 00861 10/16/2017 0:00 OR8675309 03844 03254 10/16/2017 0:00 OR8675309 03844 02882 10/16/2017 0:00 OR8675309 03844 03254 10/16/2017 0:00 OR8675309 03844 03843 10/16/2017 0:00 OR8675309 04066 69388 10/16/2017 0:00 OR8675309 04066 69388 10/16/2017 0:00 OR8675309 04067 04640 10/16/2017 0:00 OR8675309 04068 01112 10/16/2017 0:00 OR8675309 04071 01761 10/16/2017 0:00 OR8675309 04182 04183 10/16/2017 0:00 OR8675309 04182 04189 10/16/2017 0:00 OR8675309 04182 39269 10/16/2017 0:00 OR8675309 04182 39270 10/16/2017 0:00
What I am attempting to have it display
Order Model Item Due Date OR8675309 00042 01077 10/16/2017 0:00 OR8675309 03844 03254 10/16/2017 0:00 OR8675309 00042 01077 10/16/2017 0:00 OR8675309 01095 03670 10/16/2017 0:00 OR8675309 01036 01006 10/16/2017 0:00 OR8675309 04067 04640 10/16/2017 0:00 OR8675309 02882 01717 10/16/2017 0:00 OR8675309 04066 69388 10/16/2017 0:00 OR8675309 04071 01761 10/16/2017 0:00
As you may see within the desired results, I am only wanting to return the [Model] & [Item] when the [Receive Date] is less than the due date.
Thank you for your help and let me know what other information would be helpful.
For the same Iteam and Model, there are multiple reveive date? If one [Receive Date] is less than the due date, and another [Receive Date] is more than the due date, should it be returned? And do you have Due Date column in your table?
Regards,
Charlie Liao
I do have a due date column within a [Orders] dataset, as well as a [DateKey] for managing timelines. To answer your question regarding the Model|Item, correct I only want to display those which are `receiving` before the due date of the order.
Hi @adamnimmo,
Share the entire dataset (including the due date column).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |