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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
yfquirogah
Helper I
Helper I

Filters with visualization

Hi guys,

 

I'm working on a dashborad and while using it I realized something I'm not sure how to fix.

 

So, I have 2 graphics: The firstone is a donut chart which divides the population by gender and shows me the amount on each one and the porcentage, and the second one, which is a column chart, shows the amount by group.

 

Captura1.JPGCaptura2.JPG

 

This two charts are connected to basically the same data base and are on the same dashboard.

The problem, or what I want to try to change is, for example, when I select female option directly on the first chart the second one changes accordingly and shows me the amount of females on each one of the groups, which its ok, but when I try it the other way around (to select any group on the second chart), the fisrt one shows me the % on each gender from the total original value, not the amount on the group selected.

 

If I select the group 0-IV which has 0,3k population I want to see in the donunt chart the porcentage of each gender out of those 0,3k, not the total amount.

 

Any idea on how could I do this? Is it even possible?

 

Thanks in advance for any help you can give me.

 

 

1 ACCEPTED SOLUTION
nickyvv
Most Valuable Professional
Most Valuable Professional

Hi @yfquirogah

 

this is certainly possible. I think you should have a look at the visual interactions of your visuals and set them to the right properties.

 

There are 3 options between visuals, if the selected visualization should:

  • cross-filter one of the other visualizations on the page, select the filter icon in the upper right corner of that visualization 
  • cross-highlight one of the other visualizations on the page, select the highlight icon
  • have no impact on one of the other visualizations on the page, select the no impact icon
     


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

Blog: nickyvv.com | @NickyvV


View solution in original post

1 REPLY 1
nickyvv
Most Valuable Professional
Most Valuable Professional

Hi @yfquirogah

 

this is certainly possible. I think you should have a look at the visual interactions of your visuals and set them to the right properties.

 

There are 3 options between visuals, if the selected visualization should:

  • cross-filter one of the other visualizations on the page, select the filter icon in the upper right corner of that visualization 
  • cross-highlight one of the other visualizations on the page, select the highlight icon
  • have no impact on one of the other visualizations on the page, select the no impact icon
     


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

Blog: nickyvv.com | @NickyvV


Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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