Forum Discussion
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:
6 Replies
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-Forum/ba-p/963216
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/1447523Yes 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?
