Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
TableA contains:
Some emails only order 1 product, while others order multiple products.
I want to display a visual showing the various distinct counts of the Product ID column on the Y-Axis, and the distinct count of Emails on the X-Axis. Basically I want to show how many different Emails have ordered 1 product, 2 products, 3 products, etc.
How do I accomplish this?
Solved! Go to Solution.
Hi @JustSayJoe
In Power Query
Starting with this data
Group the Email column using the Distnict Count of the Product column
Then group the Email column by the Distinct Count of the Email coumn
Plot that data, Number of Products needs to be on the x-axis
You can see that
1 product was bought by 1 email
4 products were bought by 2 emails
5 products were bought by 2 emails
7 products were bought by 1 email
Regards
Phil
Proud to be a Super User!
Hi @JustSayJoe
In Power Query
Starting with this data
Group the Email column using the Distnict Count of the Product column
Then group the Email column by the Distinct Count of the Email coumn
Plot that data, Number of Products needs to be on the x-axis
You can see that
1 product was bought by 1 email
4 products were bought by 2 emails
5 products were bought by 2 emails
7 products were bought by 1 email
Regards
Phil
Proud to be a Super User!