Forum Discussion
Visual
I want to create a chart/visual with region-wise top performer AE(rep) with total sale and max sale and also have want to show rep name. Below is the table visual created in powerBI, please suggest how to make some nice chart out of it
| SalesRepName | Region | Max Sale | Total_Region |
| A1 | B1 | $20,745,938 | 62,237,814 |
| A2 | B2 | $16,818,637 | 50,455,911 |
| A3 | B3 | $12,478,640 | 37,435,920 |
| A4 | B4 | $8,866,849 | 26,600,547 |
| A5 | B5 | $7,530,951 | 22,592,853 |
| A6 | B6 | $6,495,316 | 19,485,948 |
| A7 | B7 | $5,636,883 | 16,910,649 |
| A8 | B8 | $4,609,530 | 13,828,590 |
| A9 | B9 | $3,847,241 | 11,541,723 |
| A10 | B10 | $3,645,320 | 10,935,960 |
| A11 | B11 | $2,618,073 | 7,854,219 |
| A12 | B12 | $2,564,695 | 7,694,085 |
| A13 | B13 | $2,535,246 | 7,605,738 |
| A14 | B14 | $2,408,650 | 7,225,950 |
| A15 | B15 | $1,809,293 | 5,427,879 |
| A16 | B16 | $1,633,131 | 4,899,393 |
| A17 | B17 | $1,560,500 | 4,681,500 |
| A18 | B18 | $1,196,694 | 3,590,082 |
It was made with Charticulator, but could be made to look much nicer.
Pat
6 Replies
One good option is to just add data bars to a matrix and create a chart out of it like this.
To add text to a visual, you will need a custom visual or to use Charticulator like below. Link below on how to use it, if interested.
(15) Austin Power BI User Group - Charticulator 101 - YouTube
Pat
Anonymous , All region are unique , but a measure like this should work
Measure 2 = CALCULATE(SUM(TOPNP[ Total_Region ]),TOPN(1,ALLSELECTED(TOPNP[SalesRepName]),CALCULATE(sum(TOPNP[Total_Region]))), VALUES(TOPNP[SalesRepName]))Or refer this
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
Thanks, I already created data. I want to know how to make some chart for this(table visual I gave earlier).The table visual has a already has a measure. I want create a chart with region-wise top performer AE(rep) with total sale and max sale and also have want to show rep name. The data is in table visual format but how to represent in chart.
