Forum Discussion
Slicers with multiple conditions
I have a set of data as follow:
I am creating a matrix visual that looks like this:
My question is:
Is there a way to create a slicer to filter the matrix, eg:
If the users want to see all the Items with (Cat 3, Attribute 1 greater than 3) and (Cat 1, Attribute 4 less than 7), which will be only Item 2 in this case, how can this be achieved?
Ideally the users will be able select which category(ies) and which attribute(s) to filter, as there may be quite a number of categories and attributes.
Thanks.
1 Reply
- foodd
Community Champion
Please provide your work-in-progress Power BI Desktop file and a source data file in Excel format (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
