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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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