build report for top 10 users records and rest records as others

[Shine_456]

Hi All,

I would like to build a report to get top 10 users records and rest users as others. 

 How to proceed to build this and queries for that?

Please help me on this.

[ppm1 · Accepted solution]

You can follow this approach explained on SQLBI.

Filtering the top products alongside the other products in Power BI - SQLBI

Or do it all in a Deneb visual as shown in this video.

https://www.youtube.com/watch?v=-F_k284kO64&t=3s

Pat