Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello @Anonymous
This is what I have tried to recreate your scenario:
Sample Dataset:
Visuals by customer & product:
Is this what you are looking for?
If not, then please share more details on the requirement.
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
@Anonymous
Are you trying to create a frequency distribution chart (something like a histogram)?
In this case, this is what I have come up with:
Table =
SUMMARIZE (
dtSales,
dtSales[Order Quantity],
"Customer Count", COUNTA ( dtSales[Customer Name] )
)
Visual:
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
@Anonymous
Did I answer your query?
Please confirm.
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Hi @vivran22 ,
Apologies for slow reply, I wasn't in work yesterday.
The calculated table looks good, as does the chart. I was looking for order quantity along the x axis and customer count along the y axis, so I can make that change.
The only remaining issue is that this represents the full dataset. My report has a date slicer that I would like this table/chart to change depending on what date period they choose, eg week, month, quarter, year.
Is this possible?
@Anonymous
In this case, I would recommend using the "Group By" option in Power Query by taking the reference of the parent table:
Keep the date column from the parent table
You can then create & filter your visuals accordingly and any changes in the parent table will be reflected here:
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
The solution you've provided works to a certain extent, but not in the way that solves my issue.
As you can see from my column chart in my second post above, I want to group by the number of orders made during set time period. So using your example, Grant Carroll and Skye Norling have two orders each (regardless of quantity ordered), the rest has had one order.
So the bar chart would show 8 customers ordering once and 2 customers ordering twice.
The groups would have to be calulcated on the fly (dependant on date slicer) and be used to categorise the number of customers in each order count group.
@Anonymous
I am not sure if I have understood your explanation correctly.
The current solution(with Power Query Group By) is also giving the exact same results. The only difference is that now we have included a dimension of date with it:
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
@vivran22 Hmmm... I don't have access to your dataset in your pbix file, so can't double check.
But using the group by solution, you're grouping by order quantity. I want to group by the number of orders, not by order quantity. So looking at your data snippet, grouping by order quanitity, would result in 10 different groups (as each row has a different quantity amount), but my desired result would be two groups; one group showing 1 order made with 8 individuals in it, a second group with 2 orders made with 2 individuals in it (Grant Carroll and Skyne Norling).
Does that make sense? If you think your solution is still correct, would you be able to make your dataset available, so I can cross check with your end result please?
Thanks for your help.
@Anonymous
You can find the sample dataset here
and the pbix file here
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
@vivran22 Thanks for the dataset, that's helpful.
So in your dataset, you've grouped by order count, so there are 165 orders with an order quantity of 1. But that's not what I'm looking for. I'm looking to provide a chart that shows how many times people have ordered.
So using your dataset, 6 people have ordered once.
Craig Carreira |
Dorothy Dickinson |
Maureen Grace |
Maria Etezadi |
Sample Company A |
Natalie DeCherney |
My chart would like the following:
Does this clarify it?
Hi @Anonymous ,
Can you please share a dummy file? Or please share some sample data and more details like relationships among many tables and among the tables and the columns. We will understand clearly and solve it quickly.
How to Get Your Question Answered Quickly
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |