Dynamic Top N based on Field Parameter Measure Slicer

[eliasayyy]

Hello Everyone I have a table :

Campaign	Impressions	Clicks	Cost
Camp A	97020	19076	29.02
Camp B	68593	9586	43.53
Camp C	74586	2737	36.35
Camp D	68567	16793	19.12
Camp E	79968	10998	34.62
Camp F	84165	9458	30.22
Camp G	9086	13350	22.57
Camp H	53139	3415	31.65
Camp I	59105	3674	29.83
Camp J	68719	17996	30.36

i created 5 measures

Total Impresions = SUM(table[Impressions])

Total Link Clicks = SUM(table[Clicks])

Total Cost = SUM(table[Cost])

CTR = DIVIDE([Total Link Clicks] , [Total Impressions] , 0 )

CPC = DIVIDE([Total Cost] , [Total Link Clicks] , 0 )

i created a field parameter for the measures and named it "Measure Slicer"

I added a Column Chart Visual and in the x- axis , the campaign name and y-axis my "Measure Slicer" measures

I added the "Measure Slicer" Slicer and I'm able to switch between measures easily.

now i want to show top 3 campaigns DESC based on each measure selected, any idea how to do it?

[tamerj1 · Accepted solution]

Hi @eliasayyy 
Please refer to attached sample file with the solution