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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Help with column chart when filtering

I have a simple column chart, as shown below.  

 

ADB8335_1-1717775054635.png

 

 

I have another visual in the report that has category data and when I select a category in that visual it interacts with the column chart, which is the expected behavor.  

 

ADB8335_2-1717775101562.png

 

The numbers that are shown are correct, but it is a bit misleading when the bars for the months with 0 are all different sizes and some are bigger than the month with 2.  I understand that the little sliver of blue in 2023 Jul represents the 2, but it is hard to see.  Is it possible to have the chart update so that the bars are just the size of the selected category and not the total?

1 ACCEPTED SOLUTION
jgeddes
Super User
Super User

You can use the 'Edit interactions' button on the format ribbon to control how the filtering is applied from visual to visual.

jgeddes_0-1717775970891.png

 

Click on the visual that is your filtering 'source'.

After clicking on the 'Edit interactions' button the remaining visuals on your page will have icons show up in the top right corner.

jgeddes_1-1717776046775.png

Click the icon with the little filter symbol on it and it will change how the visual responds to filters from the 'source' visual.

You can also turn off filtering here so that a visual does not respond to specific other visuals.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
jgeddes
Super User
Super User

You can use the 'Edit interactions' button on the format ribbon to control how the filtering is applied from visual to visual.

jgeddes_0-1717775970891.png

 

Click on the visual that is your filtering 'source'.

After clicking on the 'Edit interactions' button the remaining visuals on your page will have icons show up in the top right corner.

jgeddes_1-1717776046775.png

Click the icon with the little filter symbol on it and it will change how the visual responds to filters from the 'source' visual.

You can also turn off filtering here so that a visual does not respond to specific other visuals.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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 MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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