I am working on a model that filters items based on the criteria given in the slicers. In this I want to filter the item through three slicers
- Hierarchy Slicer
- Attribute Slicer
- Attribute Value Slicer.
As an example, let’s say in second slicer I want to filter an item using two attributes (STANDARD, FINISH) with values (ISO 4014, NO SURFACE TREATMENT). Meaning I want to filter (see) the item which has ISO 4014 as STANDARD and NO SURFACE TREATMENT as FINISH. But when I try to do this (refer screen shot) it is not filtering for the ‘AND’ condition. It is filtering for ‘OR’ condition (i.e it filters all materials which has either NO SURFACE TREATMENT as FINISH ‘OR’ STANDARD as ISO 4014, which I don’t want. I want to filter the material which has both NO SURFACE TREATMENT as FINISH and ISO 4014 as STANDARD.
How can I achieve my requirement?Snap from Power Bi Screen
I have tried applying the DAX measures in slicers as per these YouTube video and blog. But it didn’t help.
- https://www.youtube.com/watch?v=tONOosN1xAs
2.https://radacad.com/slicer-with-and-condition-in-power-bi
I am open to any suggestions to achieve my end result.
Vignesh K is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.