Forum Discussion
Visual
It was made with Charticulator, but could be made to look much nicer.
Pat
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.
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.