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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
fahadqadir
Helper I
Helper I

On Filtering the matrix Results are different.

I want to use the slicer (months since first purchase) (above) to filter the matrix on the left WITHOUT CHANGING THE NUMBERS IN the matrix.

The numbers in the matrix are correct as displays.

 

I also want the blue slicer to still work.

The matrix is currently correct if you SLICE on e.g. country = NL. But if you use the months since first purchase slicer the numbers in the matrix change, i don't want that.

 

 

So what I expect if I filter on Months since first purchase = 16 + 18

 

Please download the .pbix file from here:

https://drive.google.com/file/d/1D_5tzrsKXOLgC7YBT8liksnElDml-26h/view?usp=sharing

8 REPLIES 8
fahadqadir
Helper I
Helper I
Anonymous
Not applicable

you need to select edit interactions

@Anonymous can you please explain? I didn't find any solution.

Yes, but numbers are different.

 

Anonymous
Not applicable

did you removed interaction of slicer with matrix?

Yes, but same issue matrix is filtered and numbers are changed.

I need to display same numbers when i filter the matrix (column).

 

fahadqadir
Helper I
Helper I

@Anonymous ?

 

Anonymous
Not applicable

Simply select the slicer and Screenshot 2022-02-08 175107.png
good to go 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.