The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
you need to select edit interactions
@Anonymous can you please explain? I didn't find any solution.
Yes, but numbers are different.
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).
@Anonymous ?
Simply select the slicer and
good to go
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
21 | |
14 | |
14 | |
9 | |
7 |