Forum Discussion
Pie chart filter
| Name | MAJOR | BACKGROUND | STATUS | GENDER |
| NICK | ENGLISH | TRADING | STUDENT | F |
| JACK | ENGLISH | TRADING | STUDENT | M |
| JONHNSON | ENGLISH | TRADING | TEACH | M |
| ADA | ENGINEERING | MARKETING | TEACH | M |
| MIA | LOGISTIC | SUPPLY CHAIN | TEACH | M |
| ELA | INTERNATIONAL ECONOMICS AND TRADING | MARKETING | TEACH | M |
| ZERO | LOGISTIC | SUPPLY CHAIN | STUDENT | M |
| FISHHING | MATH | MARKETING | STUDENT | M |
| LULU | MATH | MARKETING | TEACH | F |
| LALO | ENGINEERING | MARKETING | TEACH | c |
I got this table as my database. I would like to create two pie charts that display two team: count of teach team by gender and count of student team by gender.
This chart looks good but once I click on it, the other pie chart other gender turn into 0. As you can see, I select Student Team M and Teach Team F is 0.
I used this two dax functions, Please correct me.
Hi, tyan
I think you may need to disable the interaction between the two reports.
Please check my sample file for more details.
Related thread：
Change how visuals interact in a Power BI report
Edit Visual Interaction Power BI
Best Regards,
Community Support Team _ Eason
3 Replies
tyan , Try like
COUNT OF STUDENT = CALCULATE(COUNT(Sheet1[GENDER]),filter(Sheet1, Sheet1[STATUS]="STUDENT"))
COUNT OF TEACH = CALCULATE(COUNT(Sheet1[GENDER]),filter(Sheet1,Sheet1[STATUS]="TEACH"))Hi, tyan
I think you may need to disable the interaction between the two reports.
Please check my sample file for more details.
Related thread：
Change how visuals interact in a Power BI report
Edit Visual Interaction Power BI
Best Regards,
Community Support Team _ Eason
