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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.