Stacked Column Chart with a dynamic top n as a legend

[tintin64]

Hello guys, I have the data  of 5 different companies,  selling 10 different products across 3 different region across various time frames. I need to make a stacked column chart which shows  (the top 3 products +others)   as legend based on slicer selection.
(different slicer selection have different top 3 and based on slicer selection always the top 3 and others must be recalculated)

[Ashish_Mathur]

Hi,

I have solved a similar problem in the attached files.

[tintin64]

[Rupak_bi · Accepted solution]

Hi @tintin64 

Based on your sample data, the logic has been created. Hope this solves your purpose. you need to create a product master table and a measure to canculate topN. plz dont create any relationship between tables. Here Tbl3 is a table of single value vreated by manual entry.

[tintin64]

Thank you very much, it worked

[Rupak_bi]

please share sample data with desired output along with slicer details.