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.
I'm encountering a challenge with Power BI. I have a table containing customer orders, with columns for date, customer number, and item. My objective is to create a sheet with two slicers:
Then, I need to generate a table that lists all customers who have ordered any combination of items from slicer 1 but nothing from slicer 2. I intend to use this table for identifying cross-sales opportunities for our marketing team.
I would greatly appreciate any assistance with this.
cust_num | item | ship_date |
100003 | 104 | 4/17/2024 |
100003 | 104 | 4/18/2024 |
100003 | 104 | 4/19/2024 |
100003 | 682 | 4/15/2024 |
100003 | 682 | 4/18/2024 |
100003 | 682 | 4/22/2024 |
100003 | 972 | 4/16/2024 |
100003 | 972 | 4/18/2024 |
100003 | 974 | 4/15/2024 |
100003 | 974 | 4/16/2024 |
100003 | 974 | 4/17/2024 |
100003 | 974 | 4/18/2024 |
100003 | 974 | 4/19/2024 |
100003 | 974 | 4/22/2024 |
100003 | 975 | 4/15/2024 |
100003 | 975 | 4/16/2024 |
100003 | 975 | 4/17/2024 |
100003 | 975 | 4/18/2024 |
100003 | 975 | 4/19/2024 |
100003 | 976 | 4/15/2024 |
100003 | 976 | 4/16/2024 |
100003 | 976 | 4/17/2024 |
100003 | 976 | 4/18/2024 |
100003 | 976 | 4/19/2024 |
100003 | 976 | 4/22/2024 |
100003 | 977 | 4/15/2024 |
100003 | 977 | 4/16/2024 |
100003 | 977 | 4/18/2024 |
100003 | 977 | 4/22/2024 |
100003 | 978 | 4/15/2024 |
100003 | 978 | 4/16/2024 |
100003 | 978 | 4/17/2024 |
100003 | 978 | 4/18/2024 |
100003 | 978 | 4/19/2024 |
100003 | 979 | 4/19/2024 |
100003 | 980 | 4/15/2024 |
100003 | 980 | 4/16/2024 |
100003 | 980 | 4/17/2024 |
100003 | 980 | 4/19/2024 |
100003 | 980 | 4/22/2024 |
100005 | 104 | 4/17/2024 |
100005 | 104 | 4/18/2024 |
100005 | 104 | 4/19/2024 |
100005 | 682 | 4/15/2024 |
100005 | 682 | 4/18/2024 |
100005 | 682 | 4/22/2024 |
100005 | 972 | 4/16/2024 |
100005 | 972 | 4/18/2024 |
100005 | 974 | 4/15/2024 |
100005 | 974 | 4/16/2024 |
100005 | 974 | 4/17/2024 |
100005 | 974 | 4/18/2024 |
100005 | 974 | 4/19/2024 |
100005 | 974 | 4/22/2024 |
100005 | 975 | 4/15/2024 |
100005 | 975 | 4/16/2024 |
100005 | 975 | 4/17/2024 |
100005 | 975 | 4/18/2024 |
100005 | 975 | 4/19/2024 |
100005 | 976 | 4/15/2024 |
100005 | 976 | 4/16/2024 |
100005 | 976 | 4/17/2024 |
100005 | 976 | 4/18/2024 |
100005 | 976 | 4/19/2024 |
100005 | 976 | 4/22/2024 |
100005 | 977 | 4/15/2024 |
100005 | 977 | 4/16/2024 |
100005 | 977 | 4/18/2024 |
100005 | 977 | 4/22/2024 |
100005 | 978 | 4/15/2024 |
100005 | 978 | 4/16/2024 |
100005 | 978 | 4/17/2024 |
100005 | 978 | 4/18/2024 |
100005 | 978 | 4/19/2024 |
100005 | 979 | 4/19/2024 |
100005 | 980 | 4/15/2024 |
100005 | 980 | 4/16/2024 |
100005 | 980 | 4/17/2024 |
100005 | 980 | 4/19/2024 |
100005 | 980 | 4/22/2024 |
so using the template in the picture i want to be able to organize the attached data so that i can select that the customer has ordered 974 and 975 for example and has not ordered 458 and the resulting table should give me the cust num of 100003 and 100005.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
51 | |
44 | |
16 | |
12 |