Filter depending on two columns

[SAPpowerbi]

Hello Team,

I Need help on below -

I have two column like   -Location 1 and Location 2 .

as of now i have two filters for selection like -

(Filter 1= Location 1 - Yes , No)

(Filter 2= Location 2 - Yes , No)

Below is the Table 

Country Name	Location 1	Location 2
ABC	Yes	Yes
India	No	yes
UK	yes	yes

Need below Output-

Filter Location =

Location 1 - yes

Location 1 No

Location 2 -yes

Location 2 -No

Please help me to used only one filter using two columns.

Thank you in advance .

[ryan_mayu · Accepted solution]

@SAPpowerbi 

just like what @mohammedadnant  suggest, unpivot columns.

Then you can merged columns 

or add both attribute and value column to slicer.

[mohammedadnant]

Hi @SAPpowerbi 

You can do this in Power Query

1. Select the Location1 & Location2 column --> Top ribbon Transform --> Unpivot Columns --> that's it,

Please check this video if you are not clear..

https://youtu.be/s7iwN_X82UI