Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
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
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
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
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
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
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 |
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
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |