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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
ร’Scar
New Contributor II

Stacked bar chart: Avoiding bars without value

Hi, folks.

 

A quick and easy issue. 

How could I hide bars without values when I make a selection in a visual object?

 

I mean, using the image below as an example, if I select "January" on the left I would like to see on the right only the countries with data, not all of them even the countries without data. For example, Czech Rep should be hidden in the image below

 

I guess I close to fix it, but I still havenยดt found the proper menu.

 

Thank you in advance, guys.

 

ร“scar

 

 

Scar_1-1695293060633.png

 

 

1 ACCEPTED SOLUTION
lbendlin
Esteemed Contributor III
4 REPLIES 4
lbendlin
Esteemed Contributor III

The "proper menu"  would be to change the default interaction from "cross highlighting"  to "cross filtering".  You want to think long and hard before changing that setting.

ร’Scar
New Contributor II

Hi, Ibendlin. Thank for the update.

But... Where could I switch that highlighting vs filtering?

I am trying to find out more through the Visualization options but Iยดm still lost.

 

Any insight or clue for me?

 

Thank you again

 

Best

lbendlin
Esteemed Contributor III

ร’Scar
New Contributor II

Hi again. Thank you for the trick. Impressive performance, just what I looked for.

 

Best

Helpful resources

Announcements
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

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

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.

Top Solution Authors
Users online (207)