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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
wltrrpo
New Member

Pie Chart Multiple Filter

Hi all,

 

I would like to know if there is a way to achieve a filter of a filter with pie charts.

 

Having a database with 11588 employees:

 

Genre:

  1. 6338 Females
  2. 5250 Males

Level:

  1. 10570 Junior
  2. 1018 Senior

 

How can I, using the pie charts filters (onclick filters), show how many Seniors Females are in my database; First filtering the Genre and then filtering the Level.

 

I have a table in I like to list in that table that results.

 

Thanks in advance.

1 REPLY 1
v-sihou-msft
Microsoft Employee
Microsoft Employee

@wltrrpo

 

In this scenario, you can only put both Genre and Level field into Legend box in Pie Chart. Then you can choose "click to drill down" to select Senior under Female. 

 

Capture.PNG

 

Regards,

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors