how to set up a table with a top 10?

[vitexo87]

it is possible to create a graph of the table type to present only the 10 highest values? is there any native configuration on the object or have to create a specific measure for this?

[v-shex-msft · Accepted solution]

Hi @vitexo87,

You can simply use query to achieve your requirement, sample:

Test table:

Duplicate it, then rename and sort the table by Amount:

Click on keep rows button, choose keep top rows, then input 10:

Regards,

Xiaoxin Sheng

[Sean]

@vitexo87

Look at this post - we did this with a pie chart and a table - it works the same way

http://community.powerbi.com/t5/Desktop/How-to-display-two-measures-in-a-pie-chart-with-legend/m-p/3...

[Vvelarde]

hi @vitexo87

With a measure with RankX and level filter to Rank less or equal than to 10.