TopN Slicer

[MarieAmell]

Hi All,

I'd like to add a slicer to display the top 5, 10, 20 or All of my advertisers.

• I have created a table "TopN_Value" as follow :

• Then, I created the measure :

_Top N Adv = CALCULATE(

    [_Spends (€)]

    , TOPN(TopN_Value[Valeur N_value], ALL('Data'[Advertiser]), [_Spends (€)]), values('Data'[Advertiser])

)

• It works when I have only spends by advertisers :

• But when I want to add a legend, it doesn't work anymore :

If someone could explain to me what's wrong and how I can correct that, it would be awesome !

Thanks a lot

_____________________________________________________________________________________________________________________________

I'd like to have a slicer to select the number of advertisers to display : this model will be used by different people on different markets, and sometimes, we'll have 15 advertisers, so we could display them all, but sometimes, we have many more.

I have created a slicer, which works when I have only the total by advertisers, but on the 2 graphs below I'd like to display the same 5, 10, 20 or All advertisers, with the detail of media or by month, the top 5, 10 or 20 adv, and it doesn't work.

I have attached the file, if someone could have a look and give me a solution, it would be very nice 😊

Thanks a lot in advance for your help.

Regards

[Idrissshatila]

Hello @MarieAmell ,

check this https://youtu.be/0-90XPWIekA

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[MarieAmell]

Tbanks for your quick reply, but it's not really what I'm trying to do. I try to attach my pbix file, but I don't know how 😊