Column Visual / quartiles based on revenue

[Sirhawk3017]

how in the world can I create quartiles and then show each quartile in a column chart showing revenue in reach quartile.

I can't share the file as it's pretty sensitive information.

[Sirhawk3017]

Yes my apologies. Here is some sample data. Each month the customer will report a new number. The data below is Jan through September.

Raw Data:

Customer Name	Report Period	Total Sales
Tim	1/1/2024	$                43,112
Tim	2/1/2024	$                22,804
Tim	3/1/2024	$                86,125
Tim	4/1/2024	$                21,571
Tim	5/1/2024	$                25,151
Tim	6/1/2024	$                   7,215
Tim	7/1/2024	$                73,575
Tim	8/1/2024	$                91,976
Tim	9/1/2024	$                59,749
Bill	1/1/2024	$                71,648
Bill	2/1/2024	$                76,745
Bill	3/1/2024	$                90,196
Bill	4/1/2024	$                95,726
Bill	5/1/2024	$                55,522
Bill	6/1/2024	$                39,189
Bill	7/1/2024	$                11,037
Bill	8/1/2024	$                40,515
Bill	9/1/2024	$                86,531
Luke	1/1/2024	$                21,350
Luke	2/1/2024	$                34,721
Luke	3/1/2024	$                80,451
Luke	4/1/2024	$                73,215
Luke	5/1/2024	$                75,348
Luke	6/1/2024	$                76,996
Luke	7/1/2024	$                   8,683
Luke	8/1/2024	$                89,623
Luke	9/1/2024	$                75,217
Mindy	1/1/2024	$                76,899
Mindy	2/1/2024	$                27,511
Mindy	3/1/2024	$                15,318
Mindy	4/1/2024	$                19,369
Mindy	5/1/2024	$                37,522
Mindy	6/1/2024	$                   3,097
Mindy	7/1/2024	$                13,005
Mindy	8/1/2024	$                73,803
Mindy	9/1/2024	$                65,727
Jerry	1/1/2024	$                29,481
Jerry	2/1/2024	$                55,209
Jerry	3/1/2024	$                67,516
Jerry	4/1/2024	$                46,142
Jerry	5/1/2024	$                45,322
Jerry	6/1/2024	$                68,434
Jerry	7/1/2024	$                84,485
Jerry	8/1/2024	$                34,446
Jerry	9/1/2024	$                26,903
Sarah	1/1/2024	$                63,375
Sarah	2/1/2024	$                20,502
Sarah	3/1/2024	$                   5,951
Sarah	4/1/2024	$                53,852
Sarah	5/1/2024	$                43,576
Sarah	6/1/2024	$                39,777
Sarah	7/1/2024	$                34,852
Sarah	8/1/2024	$                14,143
Sarah	9/1/2024	$                22,581
James	1/1/2024	$                53,369
James	2/1/2024	$                85,141
James	3/1/2024	$                25,949
James	4/1/2024	$                   7,440
James	5/1/2024	$                60,677
James	6/1/2024	$                53,525
James	7/1/2024	$                41,336
James	8/1/2024	$                11,581
James	9/1/2024	$                26,477
William	1/1/2024	$                79,331
William	2/1/2024	$                64,156
William	3/1/2024	$                13,397
William	4/1/2024	$                97,307
William	5/1/2024	$                10,757
William	6/1/2024	$                28,960
William	7/1/2024	$                88,824
William	8/1/2024	$                89,440
William	9/1/2024	$                49,574
Mark	1/1/2024	$                   4,314
Mark	2/1/2024	$                52,581
Mark	3/1/2024	$                76,647
Mark	4/1/2024	$                46,278
Mark	5/1/2024	$                   4,007
Mark	6/1/2024	$                61,814
Mark	7/1/2024	$                84,624
Mark	8/1/2024	$                16,522
Mark	9/1/2024	$                19,546
David	1/1/2024	$                37,749
David	2/1/2024	$                78,418
David	3/1/2024	$                   4,528
David	4/1/2024	$                17,557
David	5/1/2024	$                   9,529
David	6/1/2024	$                49,223
David	7/1/2024	$                80,976
David	8/1/2024	$                62,420
David	9/1/2024	$                87,813
Judy	1/1/2024	$                52,640
Judy	2/1/2024	$                78,516
Judy	3/1/2024	$                66,612
Judy	4/1/2024	$                46,587
Judy	5/1/2024	$                94,147
Judy	6/1/2024	$                60,352
Judy	7/1/2024	$                42,243
Judy	8/1/2024	$                   7,665
Judy	9/1/2024	$                69,722
Daniel	1/1/2024	$                   5,177
Daniel	2/1/2024	$                84,812
Daniel	3/1/2024	$                13,923
Daniel	4/1/2024	$                93,405
Daniel	5/1/2024	$                44,379
Daniel	6/1/2024	$                72,480
Daniel	7/1/2024	$                77,391
Daniel	8/1/2024	$                21,080
Daniel	9/1/2024	$                   4,591

What I'd like to see in a column visual. Ranks are based on total that each customer pulls in.

[lbendlin · Accepted solution]

With a little more pep:

[Sirhawk3017]

Wow what you do in PowerBI is next level. I'm very impressed. I understand measures, but what does the e mean. Also what if I wanted to see it just for YTD sales? 

[lbendlin]

FX means "calculated column resulting in a text". The E is actually a Sigma, and means "calculated column resulting in a number".

You can add your own YTD filter.

[Sirhawk3017]

Thank you again for your help!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

"I can't share sample data"  helps neither you not us.

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...