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.
Hello!
I have a list of Customer IDs, Dates, City, and State. I am trying to figure out how to show all the customers that have attended the first show date, the second show date, and then both dates in a bar graph or something equally digestible. I’d like to show both distinct and total if possible.
An exerpt of my data:
Things I have tried:
Creating a matrix with count of Date which works until I try to get it into a visualization.
Creating a column of show count:
Show Count = CALCULATE(COUNTA(Sheet1[Cust ID]),FILTER(Sheet1,Sheet1[Cust ID]=EARLIER(Sheet1[Cust ID],1)))
That didn’t quite give me what I need because I really want to show 1s and 0s so I can aggregate the counts into a graph.
Creating columns for show 1, show 2, and both:
Show 1 = CALCULATE(COUNTROWS(Sheet1),FILTER(Sheet1,Sheet1[Date].[Year]=2019))
But that gave me a total count not a row by row.
What I have in my head:
Thank you!
Solved! Go to Solution.
here is a workaround for you.pls see the attachment below
Proud to be a Super User!
Yep! Here is the data pasted. And below is my expected output with dummy data. I don't have it based on the current data I have because I can't get there yet.
Cust ID | Date | City | State |
100000000000192 | 3/30/2019 | New Orleans | LA |
100000000000192 | 3/30/2019 | New Orleans | LA |
100000000000912 | 3/30/2019 | New Orleans | LA |
100000000002976 | 3/30/2019 | New Orleans | LA |
100000000002976 | 3/30/2019 | New Orleans | LA |
100000000002976 | 3/30/2019 | New Orleans | LA |
100000000042960 | 3/30/2019 | New Orleans | LA |
100000000050352 | 3/30/2019 | New Orleans | LA |
100000000050352 | 3/30/2019 | New Orleans | LA |
100000000050352 | 3/30/2019 | New Orleans | LA |
100000000061920 | 3/30/2019 | New Orleans | LA |
100000000093120 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000096768 | 3/30/2019 | New Orleans | LA |
100000000229680 | 3/30/2019 | New Orleans | LA |
100000000229680 | 3/30/2019 | New Orleans | LA |
100000000229680 | 3/30/2019 | New Orleans | LA |
100000000297600 | 3/30/2019 | New Orleans | LA |
100000000297600 | 3/30/2019 | New Orleans | LA |
100000000386544 | 3/30/2019 | New Orleans | LA |
100000000397440 | 3/30/2019 | New Orleans | LA |
100000000397440 | 3/30/2019 | New Orleans | LA |
100000000448464 | 3/30/2019 | New Orleans | LA |
100000000476544 | 3/30/2019 | New Orleans | LA |
100000000494928 | 3/30/2019 | New Orleans | LA |
100000000589488 | 7/31/2021 | New Orleans | LA |
100000000665280 | 3/30/2019 | New Orleans | LA |
100000000665280 | 3/30/2019 | New Orleans | LA |
100000000684864 | 7/31/2021 | New Orleans | LA |
100000000703728 | 3/30/2019 | New Orleans | LA |
100000000703728 | 3/30/2019 | New Orleans | LA |
100000000994512 | 3/30/2019 | New Orleans | LA |
100000001023264 | 3/30/2019 | New Orleans | LA |
100000001023264 | 3/30/2019 | New Orleans | LA |
100000001023264 | 3/30/2019 | New Orleans | LA |
100000001023264 | 3/30/2019 | New Orleans | LA |
100000001056240 | 7/31/2021 | New Orleans | LA |
100000001289280 | 7/31/2021 | New Orleans | LA |
100000001418016 | 7/31/2021 | New Orleans | LA |
100000001434528 | 3/30/2019 | New Orleans | LA |
100000001434528 | 3/30/2019 | New Orleans | LA |
100000001434528 | 3/30/2019 | New Orleans | LA |
100000001674432 | 3/30/2019 | New Orleans | LA |
100000001674432 | 3/30/2019 | New Orleans | LA |
100000001674432 | 3/30/2019 | New Orleans | LA |
100000001997904 | 3/30/2019 | New Orleans | LA |
100000001997904 | 3/30/2019 | New Orleans | LA |
100000001997904 | 7/31/2021 | New Orleans | LA |
100000001998816 | 3/30/2019 | New Orleans | LA |
100000002059824 | 7/31/2021 | New Orleans | LA |
100000002059824 | 7/31/2021 | New Orleans | LA |
100000002101008 | 3/30/2019 | New Orleans | LA |
100000002132208 | 3/30/2019 | New Orleans | LA |
100000002155200 | 3/30/2019 | New Orleans | LA |
here is a workaround for you.pls see the attachment below
Proud to be a Super User!
you are welcome
Proud to be a Super User!
could you pls paste the sample data, not the screenshot? What's more, could you pls provide also provide the expected output which based on the sample data you provided? (the screenshot of chart in excel is also fine)
Proud to be a Super User!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |