Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
User requested to show only top 3/5/10 suburbs for each state, please suggest a chart where it picks TopN suburbs per state.
where EMP STATUS=Current
Sample data:
| EMP STATUS | STATE | SUBURB |
| Terminated FY 22-23 | WA | South Lake |
| Current | WA | East Fremantle |
| Terminated FY 24-25 | WA | Leeming |
| Terminated FY 25-26 | WA | South Lake |
| Current | WA | Rockingham |
| Current | WA | Leeming |
| Terminated FY 23-24 | VIC | Ferntree Gully |
| Terminated FY 22-23 | QLD | Mansfield |
| Terminated FY 23-24 | WA | Meadow Springs |
| Terminated FY 23-24 | NSW | Eagle Vale |
| Terminated FY 23-24 | VIC | Koo Wee Rup |
| Current | WA | Thornlie |
| Terminated FY 24-25 | NSW | Raby |
| Current | WA | Spearwood |
| Terminated FY 22-23 | WA | Warnbro |
| Terminated FY 23-24 | WA | Spearwood |
| Current | VIC | Narre Warren North |
| Current | SA | Linden Park |
| Terminated FY 24-25 | QLD | Logan Reserve |
| Current | WA | Canning Vale |
| Current | TAS | Mangalore |
| Current | WA | Waikiki |
| Terminated FY 24-25 | TAS | Tinderbox |
| Terminated FY 23-24 | VIC | Greenvale |
| Terminated FY 23-24 | WA | Palmyra |
| Current | WA | Armadale |
| Terminated FY 22-23 | WA | Pinjarra |
| Terminated FY 24-25 | QLD | Seventeen Mile Rocks |
| Current | WA | Hamilton Hill |
| Terminated FY 24-25 | WA | Success |
| Current | WA | Mosman Park |
| Terminated FY 23-24 | QLD | Kingston |
| Terminated FY 24-25 | QLD | Loganlea |
| Current | WA | Rivervale |
| Terminated FY 22-23 | WA | Bibra Lake |
| Terminated FY 25-26 | WA | Bibra Lake |
| Terminated FY 22-23 | SA | Birdwood |
| Terminated FY 22-23 | WA | Cooloongup |
| Terminated FY 24-25 | WA | Armadale |
| Current | WA | Byford |
| Current | WA | East Perth |
| Current | WA | Yangebup |
| Terminated FY 24-25 | TAS | Blackmans Bay |
| Current | TAS | Huonville |
| Terminated FY 22-23 | QLD | Algester |
| Terminated FY 24-25 | WA | Byford |
| Terminated FY 22-23 | WA | Canning Vale |
| Current | WA | Thornlie |
| Current | WA | Bicton |
Not enough sample data for a meaningful reply
Please provide sample data that covers your issue or question completely.
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
I tried using filter Top3 but it gives more than 3, as it is condidering "5 Hires as Rank 1" and all the "4 Hires as Rank 2" but not unique ranks.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!