Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
@ Greg_Deckler, @Amit
Hi,
I have a matrix visual where is use 2 measures as rows (by using "Show on rows" option). The issue I'm facing is the measures on selection of any particular cell in the matrix is not passed to the related Table visual and hence the data in Table visual is not getting filtered accordingly. Is there a solution for me to pass measure value in the selected cell to another related visual?
date 1 | date 2 | date 3 | |
Credit | -100 | -200 | -300 |
Debit | 100 | 200 | 300 |
Ex:
On clicking -100 , in above table the sum of entire column (-100 and 100) is getting passed to the related visual. That is "Credit" is not being passed. Is there a way this can be resolved?
I tried replicating this and cannot. When I click on -100 cell in the matrix I get -100 passed to my other visual. Or I am not understanding something.
See attached PBIX.
@Greg_DecklerThank you looking into the issue Greg.
I'm not able to attach the pbix file here. Hence attaching the screenshot of a sample dashboard.
If i click on -40 from my matrix, the entire column corresponding to it is being selected . And it is being passed to the table visula. I want only the -40 to be passed. How do i achieve this?
The formula used for creating the measures CREDIT and DEBIT are as follows:
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |