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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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