Top N By Month, New N Each Month

[jdriscoll]

Hi,

I have a chart that looks like the following:

I'm trying to show the top 5 per month (changing month to month), but the visual filter is only able to rank top 5 for the entire period on the chart. Is there a quick measure I can throw together to drop into the legend field here that would allow for a different 5 for each month?

[Ashish_Mathur]

Hi,

I am not sure how much i can help but i would like to try.  Share the download link of the PBI file.

[jdriscoll]

Hi,

The file is linked here. Thank you.

[amitchandak]

@jdriscoll , Simply use TOPN measure on legend

Sumx(keepfilters(TOPN(5,allselected(Table[Fruit]), calculate(Sum(Table[NumSales])), desc)), calculate(Sum(Table[NumSales])))

refer to check both TOPN and Window

Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

[jdriscoll]

Thank you for that. I tried it, but unfortunately the Legend field won't accept my new Top5 measure. See below.

This is the same issue I've been having with other measures I tried to create and use for the Legend.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.