Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer based on IF function

Hi,

I am new to Power BI world. I want to make a measure that will filter as following:

 

FO                      FP

Indonesia           Indonesia

India                   Indonesia

Indonesia           Thailand

Vietnam              Indonesia

Indonesia           India

 

I want create a measure that will retain row 1,3,5 when I select "Indonesia", other rows will not be visible. I want to create a measure using filter but not sure about the syntax.

Need Help
  • Thim's avatar
    Thim
    6 years ago

    So just to be clear.

     

    What you want is a slicer, that shows the lines from FP that has Indonesia?

     

    If this is true, then you don't need to make a meassure, you can just put the FP column in a Slicer.

     

    If you ONLY want the option to filter Indonesia you can change what options the slicer has under filter.

     

     

    Hope this was what you were looking for. :-)

1 Reply

  • Thim's avatar
    Thim
    Resolver V
    6 years ago

    So just to be clear.

     

    What you want is a slicer, that shows the lines from FP that has Indonesia?

     

    If this is true, then you don't need to make a meassure, you can just put the FP column in a Slicer.

     

    If you ONLY want the option to filter Indonesia you can change what options the slicer has under filter.

     

     

    Hope this was what you were looking for. :-)