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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Peavey
Helper III
Helper III

How to hide column chart when applying filter?

Hi,

 

I have departments and assets. When selecting department I see the assets with most cost, but I also see all the other data(transparent). As the asset number is high, I have to manually look for top 5. Is there a way to hide the assets that don't belong to selected department?

 

 

dep-asset.JPG

 

Thanks

-A-

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi,

you have su activate Edit Interactions functionality on the ribbon.

Then select Department chart: on the Asset chart you will see the different interaction types.

Now you have selected highlights

 

 

 

 

 

You have to select filter option

 

powerbi_filter.png

 

 

 

 

Regards

Lorenzo

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi,

you have su activate Edit Interactions functionality on the ribbon.

Then select Department chart: on the Asset chart you will see the different interaction types.

Now you have selected highlights

 

 

 

 

 

You have to select filter option

 

powerbi_filter.png

 

 

 

 

Regards

Lorenzo

Hi,

 

Where can I find this setting?

Anonymous
Not applicable

powerbi_edit_interactions.png

Mariusz
Community Champion
Community Champion

Hi @Peavey 

 

can you send the screenshot of your data model?

 

 

Best Regards,
Mariusz



Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

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

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.