How to create a histogram that show occurrences of client names in a column between certain dates?

[powercolor]

I have a table called Appoitments that has this format:

Date	Client Name	Invoice Total
08-Jan-2017	Maria	$100
15-Feb-2017	Maria	$50
23-Mar-2017	Roland	$75
11-May-2017	Francisco	$32
27-June-2017	Francisco	$98
16-Feb-2017	Francisco	$76
29-Mar-2017	John	$76
06-Jun-2017	John	$76
06-May-2017	Fern	$76
06-Jul-2017	Apple	$76
27-Jan-2017	Norman	$76

What I would like is to create an histogram that have bins that represent the occurance of clients between certain dates.

For example, if I set my slice date from 01-Jan-2017 to 07-Aug-2017, I would like to have the folowing histogram:

Number of client occurences (bins)	count
1	4
2	2
3	1

I tried create a new table using the groupby feature but it didn't work as it removes the date and the slice was not working anymore.

[v-huizhn-msft · Accepted solution]

Hi @powercolor,

If you want to create a histogram visual, you must add the column as Values level, you can create a group by table using the formula:

Table = SUMMARIZE(Appoitments,Appoitments[Client Name],"Number of client occurences (bins)",COUNTA(Appoitments[Client Name]))

While the table will not be automatical based on certain dates selected in slicer. Please see the knowledge base here.

If you want to get the Number of client occurences (bins) by measure, it can not be used as value in histogram chart. So we can not get the expected result as what you want. Thanks for understanding.

Best Regards,
Angelia

[Anonymous]

@powercolor

You don't really need the dates, do you? If you want to make a histogram based on clients occurences?