Forum Discussion
Solved
Column Visual / quartiles based on revenue
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.
With a little more pep:
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.
With a little more pep:
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?
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.