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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
samye228
Helper I
Helper I

Drill Down from Icon Map

Hello,

I am using the Icon Map to show Site information such as where a park is located or a specific office building. When I right click I drill down to a page that has the specific site attributes and the building(s) that are located on that site. For example, if it is a park, when drilling down it would show a list (in a table) of all the buildings and then a bar chart to indicate the different types of buildings. There might be a visitor center, ramadas and maintenance building.

 

The data is two tables, one for site and one for buildings. a site can have none or many buildings. 

 

When I drill down, the table works but the bar chart does not. It shows the correct # of all the building types and how many but then lists all the types of buildings that are available. 

 

Can someone point me to any videos that would explain drill-down or maybe what I need to do. 

 

Thank you,

Carol 

 

Screen Print, Summary page:

samye228_0-1722011015975.pngsamye228_1-1722011150445.png

 

2 REPLIES 2
Anonymous
Not applicable

Hi @samye228 ,

 

Glad to hear that your problem has been resolved. You can mark reply 2 as a solution to help more people with the same problem.

 

Best Regards,

Neeko Tang

samye228
Helper I
Helper I

Hello,

I was able to get this working by creating a table first and then changing the visual to a bar chart. When I originally created the bar chart, I must have "played" with the settings which produced the above. I think it was a good lesson for me to revert to a table to see the data and then change the visual.

Kind Regards,

Carol

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (4,759)