Top 3 for each bar in a bar chart

[abrahamfariaz]

I have a bar chart that displays the number of discrepancies per picker (person), and I want to identify the top 3 products (CUF) with discrepancies for each person. My current bar chart looks like this:

However, if I include CUF in the legend, I encounter two issues:

1) It changes the total for each bar
2) If I set a top 3 by CUF count, the chart disappears

¿Can somebody help me? Thanks!!

[Daniel29195]

@abrahamfariaz 

i took a look at the file , this is what i noticed : 

first : if we take De la Vega Walter  as  an example ,

the top 3 cuf per for him per count of cuf , have 

Recuento diferencias  , 2 of them blank, and one with one value . 

this can be seen in the visual below , as excepted : 

if this is what you want : 

this is the measure to write and you use it in the visual :

Measure 2 = 
var ds = 
TOPN(
    3,
    ALLSELECTED('329 + 12 + Artículos'[CUF]),
    [Measure],
    DESC
)

var c  = 
CALCULATE(
    [Recuento diferencias],
    KEEPFILTERS(ds)
)

return c 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[abrahamfariaz]

Hello @Daniel29195 ! Thank you very much for helping me with this challenge.
Unfortunately, I didn't understand your point with the example of De la Vega Walter. I don't have null values in the table 329 + 12 + Articles.
What I need, in case I didn't explain myself correctly, is to display the TOP 3 CUFs per person or picker. I currently solved it with a tooltip, but I would like it to be inside each bar of the chart.

[Daniel29195]

@abrahamfariaz 

this is the caluclation of yhe measure you are using in the bar chart.

so for the top3 ( base on count of cuf )   for De la Vega Walter,  this measure returns blank for 2 of the 3  .

[abrahamfariaz]

I attach the link to the file: https://drive.google.com/file/d/14YUM_UAuwwne0DF68lwCk2DySt__S-iG/view?usp=sharing

[Ashish_Mathur]

Hi,

Try this measure

Measure = CALCULATE([Recuento diferencias],TOPN(3,ALL('329 + 12 + Artículos'[CUF]),[Recuento diferencias]),VALUES('329 + 12 + Artículos'[CUF]))

Hope this helps.