https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-TreeMap-Displaying-Top-10-Categories-with-Dynamic/m-p/4317988#M11869 <P>I'm using a <STRONG>TreeMap</STRONG> in Power BI to track costs related to my import operations under 26 categories. These data change every month. Viewing all 26 categories at once makes the visualization harder to interpret. Displaying only the <STRONG>Top 10 categories</STRONG> would be sufficient.</P><P>However, if I manually exclude the remaining 16 categories from the dataset, any data that might fall into the <STRONG>Top 10</STRONG> in future months will be excluded from the visualization.</P><P>How can I dynamically display only the <STRONG>Top 10 categories</STRONG> without losing the ability to account for all 26 in future months?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Sat, 07 Dec 2024 14:34:03 GMT Gamze 2024-12-07T14:34:03Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-TreeMap-Displaying-Top-10-Categories-with-Dynamic/m-p/4317988#M11869 <P>I'm using a <STRONG>TreeMap</STRONG> in Power BI to track costs related to my import operations under 26 categories. These data change every month. Viewing all 26 categories at once makes the visualization harder to interpret. Displaying only the <STRONG>Top 10 categories</STRONG> would be sufficient.</P><P>However, if I manually exclude the remaining 16 categories from the dataset, any data that might fall into the <STRONG>Top 10</STRONG> in future months will be excluded from the visualization.</P><P>How can I dynamically display only the <STRONG>Top 10 categories</STRONG> without losing the ability to account for all 26 in future months?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Sat, 07 Dec 2024 14:34:03 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-TreeMap-Displaying-Top-10-Categories-with-Dynamic/m-p/4317988#M11869 Gamze 2024-12-07T14:34:03Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-TreeMap-Displaying-Top-10-Categories-with-Dynamic/m-p/4318081#M11871 <P>Impossible with a treemap visual.&nbsp; Top 10 has different meanings across different months.&nbsp; Keep including all items. The Treemap allows you to visually identify the top items - that's its purpose.</P> <P>&nbsp;</P> <P>If you want to compare ranking across months use a Ribbon Chart.</P> Sat, 07 Dec 2024 18:38:57 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Power-BI-TreeMap-Displaying-Top-10-Categories-with-Dynamic/m-p/4318081#M11871 lbendlin 2024-12-07T18:38:57Z