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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MagikJukas
Resolver III
Resolver III

Table and Matrix interaction when selecting

Hi,

I have these two visuals:
Table 1 contains: Material, Date and M1

Matrix 2 contains: Material, Date and M2.

 

when I select a line in T1, Matrix 2 shows the selected material from T1 as well as the date.

However, I would like Matrix 2 to show the material only and ignore the date selected in T1.

 

Is that possible somehow?

 

thanks

 

2 REPLIES 2
some_bih
Super User
Super User

Hi @MagikJukas "it depends", basically you want 2 different measure, which is esentially one measure with 2 option?

If yes, usually measure to not affect / calculate Date column could be in general

CALCULATE(
   [Your Measure],

REMOVEFILTERS(<Yourtable>[YourColumn])
)

Hope this help, kudos appreciated.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






they are two different measures.

the problem is that material and date are used in both visualizations.

therefore, when I select a line in table 1, it filters on the same material date combination in matrix 2.

I wish to filter only material in the matrix and not the combination of material and date.

 

I hope it is clearer now 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.