Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Deactivating Filtering on Subrows

I have a table in power BI called Sales. It has 3 columns, sales#(PK), customer and revenue. Customer column is not unique, meaning each customer can have multiple sales records.

Now in the report mode, I have a slicer based on the revenue and a matrix. My matrix has two rows, customer and sales# respectively and the value of my matrix is revenue. I want this slicer only filters by customer and not by sales#. when I only have my customers and not the sales# in the matrix, this slicer is working fine and giving me what I want; however when I add sales#, the slicer is filtering based on the Sales#. Is there a way that I can deactivate the filtering for sub-rows?

I need to filter the revenue based on the customers and not the sales# but I need to keep Sales# in my matrix.