how to set up a table with a top 10?

[Anonymous]

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?

[Anonymous · Accepted solution]

Hi @Anonymous,

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]

@Anonymous

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/34691

[Vvelarde]

hi @Anonymous

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