Forum Discussion

wltrrpo's avatar
wltrrpo
New Member
8 years ago

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

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    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. 

     

     

    Regards,