Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
jscivias
Helper I
Helper I

Drill down a treemap from a higher category to sub-category? (treemap w/ two different categories)

Hello, I currently have a treemap with data categorized by sector (e.g. finance), and this data is then drilled down to a sub-sector level under 'details' (e.g. credit intermediary). However, I would like to create a treemap where users can toggle between data categorized by sector, or by sub-sector-- ideally, if a user were to click on the 'finance' sector, the treemap will then show the ranking categorized by subsector only in the finance sector. OR a toggle button where the treemap is categorized by sector or sub-sector (not together, i find this hard to read). i hope i was being clear, thanks for your help. 

 

 

treemap.png

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @jscivias 

 

If I understand it correctly, the new Field Parameter feature is probably what you want. Fields in the same parameter are at the equivalent level. 

 

More reference: https://www.sqlbi.com/articles/fields-parameters-in-power-bi/ 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

3 REPLIES 3
jscivias
Helper I
Helper I

Thanks so much, field parameter was exactly what i was looking for. you mention that this is a new feature.. is there a way to keep informed of new power bi features? thanks again 

Hi @jscivias 

 

You can visit the Microsoft Power BI Blog website for updates and news. There is a feature summary blog published in every month e.g. Power BI June 2022 Feature Summary

 

Best Regards,
Jing

v-jingzhang
Community Support
Community Support

Hi @jscivias 

 

If I understand it correctly, the new Field Parameter feature is probably what you want. Fields in the same parameter are at the equivalent level. 

 

More reference: https://www.sqlbi.com/articles/fields-parameters-in-power-bi/ 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.