Variable TopN in Visual filter

[ryand009]

Hello

Is there  way to dynamically change the visual title to include the value of the Visual TopN. In the screenshot the visual title is 'Top 10 Sales by Country.' I need it to read 'Top 5 Sales by country' or what ever the value is in the Show Items.

Thaks in Advance

[ahmadibrahimbus · Accepted solution]

Countcountry = IF(ISFILTERED(table[country]), COUNTROWS(VALUES(table[country])),0)

then build another measure for the title:

• title="Top"& countcountry & "Sales by Country"
• hope this is help.