0

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

  1. Hierarchy Slicer
  2. Attribute Slicer
  3. 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? Power Bi Snap

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.

Improve this question
6
  • superuser.com/users/1247873/mayukh-bhattacharya @Mayukh Bhattacharya any idea on the above query?
    – Vignesh K
    Commented Jun 12 at 15:37
  • I can't say how to do it, but I it seems clear to me that the DAX for getting the attribute value is still listing individual values (making it an or) instead of combining them (making it and). I suggest you edit your post to include the DAX transformation you are attempting to use.
    – gns100
    Commented Jun 12 at 17:29
  • @gns100 I am a newbie to PowerBi and didn't write any DAX code to achieve my result. I referred this link radacad.com/slicer-with-and-condition-in-power-bi - But couldn't arrive at any solution. Is there any possibility, that I can achieve my result without DAX code itself?
    – Vignesh K
    Commented Jun 13 at 5:41
  • I am in no way an expert on powerBI either, moving this to their forum would probably get you an instant answer. Having said that, based on your screenshot, I believe the key is the fifth and sixth rows which is identical except for the last two columns. I think you want to transform the 5th column as headers using the 6th column as the data fields. That should get you almost all the way there. Good luck.
    – gns100
    Commented Jun 13 at 15:21
  • @gns100 Which is the correct forum to ask this powerbi questions? Can you please share me the link?
    – Vignesh K
    Commented Jun 14 at 9:17

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .