The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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