Visual

[Anonymous]

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

[mahoneypat · Accepted solution]

It was made with Charticulator, but could be made to look much nicer.

Pat

[mahoneypat]

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]

Is the below chart made out of charticulator? if not, can you please let me know how you made it or share the file

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

What about line and stacked column chart? The column shows the max sale, and the line shows the total_region.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat · Accepted solution]

It was made with Charticulator, but could be made to look much nicer.

Pat

[amitchandak]

@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/

[Anonymous]

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.