Create list based on multiple customer IDs

[Anonymous]

Hi all!

I have a list of over 50k customers, but I am only concerned with aprox 1k of them - group A and Group B.  I don't have access to the data in Excel format - I've linked Power BI directly to the company database.  How can I create two lists  of my 1k customers only (group A and Group B), using their customer number for example?  I have downloaded Power BI Filter By List, and that allows me to copy and paste my customer numbers.

I effectively want a button for each group on my dashboard - I'm not concerned about the data of the other 49k customers.

Thank you!

[Anonymous]

So my data would look something lije this, but the I have added the yellow column.  I would need to tell Power BI which customers are in Group A and B, and ignore everything else.  I will then be reporting on the two groups sales performances, but I am only interested in their data.  So I need to create a gropu or a list in Power BI to do this.

This is how I would do it in Excel for example.  There are around 1,000 customers that I need to group like this, so I was hoping there would be a quick/simple way!  Thanks

[lbendlin]

That data is not in a usable format. Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

[Anonymous]

I need to define within the dataset 2 groups of customers.  The dataset is approx 50,000 customers.  Group A will contain approx 500 customers, and group B approx 500 customers.  I effectively want to filter just group A and B - the rest can be discarded.  How can I do this without manually typing out each customer individually?  Thanks

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[Anonymous]

OK, let's try this!  Here is the data (or at least how it would look in Excel.  I know the customer ID's of all customers in Group A, and Group B.  I need a way to filter just to show these two groups of customers.  My data is being pulled from the cloud so I can't (or at least I don't think) I can create a column to calculate this.

Customer ID	City	Type	Month	Revenue
1234567	London	Retail	January	£      22,536
6549872	London	Retail	January	£      23,770
1232209	Leeds	Leisure	January	£      25,004
6547514	London	Leisure	January	£      26,238
1229851	New York	Leisure	January	£      27,472
6545156	London	Retail	January	£      28,706
1227493	Leeds	Retail	January	£      29,940
6542798	London	Finance	January	£      31,174
1225135	New York	Retail	January	£      32,408
6540440	Leeds	Finance	January	£      33,642
1222777	New York	Finance	January	£      34,876
6538082	New York	Retail	January	£      36,110
1220419	Leeds	Retail	January	£      37,344
6535724	New York	Finance	January	£      38,578
1218061	New York	Finance	January	£      39,812
6533366	London	Finance	January	£      41,046
1215703	London	Retail	January	£      42,280
6531008	Leeds	Retail	January	£      43,514

Simply put, I don't want any of the customers marked NA below to appear in my dataset.

Customer ID	City	Type	Month	Revenue
1234567	London	Retail	January	£      22,536	Group B
6549872	London	Retail	January	£      23,770	NA
1232209	Leeds	Leisure	January	£      25,004	NA
6547514	London	Leisure	January	£      26,238	NA
1229851	New York	Leisure	January	£      27,472	Group A
6545156	London	Retail	January	£      28,706	Group B
1227493	Leeds	Retail	January	£      29,940	NA
6542798	London	Finance	January	£      31,174	NA
1225135	New York	Retail	January	£      32,408	NA
6540440	Leeds	Finance	January	£      33,642	Group A
1222777	New York	Finance	January	£      34,876	Group A
6538082	New York	Retail	January	£      36,110	Group A
1220419	Leeds	Retail	January	£      37,344	NA
6535724	New York	Finance	January	£      38,578	NA
1218061	New York	Finance	January	£      39,812	NA
6533366	London	Finance	January	£      41,046	NA
1215703	London	Retail	January	£      42,280	NA
6531008	Leeds	Retail	January	£      43,514	Group B

[lbendlin]

Here is an example. Feel free to modify/adjust. It will also work when the "NA"  customers are missing from the dimension table. Understanding blank row and limited relationships - SQLBI