Forum Discussion
Visualisation for TopN suburbs per state
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 |
2 Replies
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.
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
