https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Visualisation-for-TopN-suburbs-per-state/m-p/4878076#M12918 <P>Hi,</P><P>&nbsp;</P><P>User requested to show only top 3/5/10 suburbs for each state, please suggest a chart where it picks TopN suburbs per state.</P><P>where EMP STATUS=Current</P><P>&nbsp;</P><P>Sample data:</P><TABLE><TBODY><TR><TD><STRONG>EMP STATUS</STRONG></TD><TD><STRONG>STATE</STRONG></TD><TD><STRONG>SUBURB</STRONG></TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>South Lake</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>East Fremantle</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>WA</TD><TD>Leeming</TD></TR><TR><TD>Terminated FY 25-26</TD><TD>WA</TD><TD>South Lake</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Rockingham</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Leeming</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>VIC</TD><TD>Ferntree Gully</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>QLD</TD><TD>Mansfield</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>WA</TD><TD>Meadow Springs</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>NSW</TD><TD>Eagle Vale</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>VIC</TD><TD>Koo Wee Rup</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Thornlie</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>NSW</TD><TD>Raby</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Spearwood</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Warnbro</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>WA</TD><TD>Spearwood</TD></TR><TR><TD>Current</TD><TD>VIC</TD><TD>Narre Warren North</TD></TR><TR><TD>Current</TD><TD>SA</TD><TD>Linden Park</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>QLD</TD><TD>Logan Reserve</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Canning Vale</TD></TR><TR><TD>Current</TD><TD>TAS</TD><TD>Mangalore</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Waikiki</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>TAS</TD><TD>Tinderbox</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>VIC</TD><TD>Greenvale</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>WA</TD><TD>Palmyra</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Armadale</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Pinjarra</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>QLD</TD><TD>Seventeen Mile Rocks</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Hamilton Hill</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>WA</TD><TD>Success</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Mosman Park</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>QLD</TD><TD>Kingston</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>QLD</TD><TD>Loganlea</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Rivervale</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Bibra Lake</TD></TR><TR><TD>Terminated FY 25-26</TD><TD>WA</TD><TD>Bibra Lake</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>SA</TD><TD>Birdwood</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Cooloongup</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>WA</TD><TD>Armadale</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Byford</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>East Perth</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Yangebup</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>TAS</TD><TD>Blackmans Bay</TD></TR><TR><TD>Current</TD><TD>TAS</TD><TD>Huonville</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>QLD</TD><TD>Algester</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>WA</TD><TD>Byford</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Canning Vale</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Thornlie</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Bicton</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 18 Nov 2025 00:06:35 GMT DanielASouza 2025-11-18T00:06:35Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Visualisation-for-TopN-suburbs-per-state/m-p/4878076#M12918 <P>Hi,</P><P>&nbsp;</P><P>User requested to show only top 3/5/10 suburbs for each state, please suggest a chart where it picks TopN suburbs per state.</P><P>where EMP STATUS=Current</P><P>&nbsp;</P><P>Sample data:</P><TABLE><TBODY><TR><TD><STRONG>EMP STATUS</STRONG></TD><TD><STRONG>STATE</STRONG></TD><TD><STRONG>SUBURB</STRONG></TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>South Lake</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>East Fremantle</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>WA</TD><TD>Leeming</TD></TR><TR><TD>Terminated FY 25-26</TD><TD>WA</TD><TD>South Lake</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Rockingham</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Leeming</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>VIC</TD><TD>Ferntree Gully</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>QLD</TD><TD>Mansfield</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>WA</TD><TD>Meadow Springs</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>NSW</TD><TD>Eagle Vale</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>VIC</TD><TD>Koo Wee Rup</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Thornlie</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>NSW</TD><TD>Raby</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Spearwood</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Warnbro</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>WA</TD><TD>Spearwood</TD></TR><TR><TD>Current</TD><TD>VIC</TD><TD>Narre Warren North</TD></TR><TR><TD>Current</TD><TD>SA</TD><TD>Linden Park</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>QLD</TD><TD>Logan Reserve</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Canning Vale</TD></TR><TR><TD>Current</TD><TD>TAS</TD><TD>Mangalore</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Waikiki</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>TAS</TD><TD>Tinderbox</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>VIC</TD><TD>Greenvale</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>WA</TD><TD>Palmyra</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Armadale</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Pinjarra</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>QLD</TD><TD>Seventeen Mile Rocks</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Hamilton Hill</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>WA</TD><TD>Success</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Mosman Park</TD></TR><TR><TD>Terminated FY 23-24</TD><TD>QLD</TD><TD>Kingston</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>QLD</TD><TD>Loganlea</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Rivervale</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Bibra Lake</TD></TR><TR><TD>Terminated FY 25-26</TD><TD>WA</TD><TD>Bibra Lake</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>SA</TD><TD>Birdwood</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Cooloongup</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>WA</TD><TD>Armadale</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Byford</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>East Perth</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Yangebup</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>TAS</TD><TD>Blackmans Bay</TD></TR><TR><TD>Current</TD><TD>TAS</TD><TD>Huonville</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>QLD</TD><TD>Algester</TD></TR><TR><TD>Terminated FY 24-25</TD><TD>WA</TD><TD>Byford</TD></TR><TR><TD>Terminated FY 22-23</TD><TD>WA</TD><TD>Canning Vale</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Thornlie</TD></TR><TR><TD>Current</TD><TD>WA</TD><TD>Bicton</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 18 Nov 2025 00:06:35 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Visualisation-for-TopN-suburbs-per-state/m-p/4878076#M12918 DanielASouza 2025-11-18T00:06:35Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Visualisation-for-TopN-suburbs-per-state/m-p/4878079#M12919 <P>I tried using filter Top3 but it gives more than 3, as it is condidering "5 Hires as Rank 1" and all the&nbsp;"4 Hires as Rank 2" but not unique ranks.&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 18 Nov 2025 00:24:17 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Visualisation-for-TopN-suburbs-per-state/m-p/4878079#M12919 DanielASouza 2025-11-18T00:24:17Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Visualisation-for-TopN-suburbs-per-state/m-p/4883222#M12929 <P>Not enough sample data for a meaningful reply</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>.<BR />Do not include sensitive information. Do not include anything that is unrelated to the issue or question. <BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Need help uploading data? <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank" rel="noopener">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank" rel="noopener">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> <P>&nbsp;</P> Sun, 23 Nov 2025 14:41:30 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Visualisation-for-TopN-suburbs-per-state/m-p/4883222#M12929 lbendlin 2025-11-23T14:41:30Z