Forum Discussion

SAPpowerbi's avatar
SAPpowerbi
Helper II
4 years ago
Solved

Filter depending on two columns

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 NameLocation 1Location 2
ABCYesYes
IndiaNoyes
UKyesyes

 

 

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 .

 

2 Replies