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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 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.