How to do make a selection list

[and2022]

Hi community,

I am new to Power BI and have learned a lot from your posts. Thank you all very much.

Today I met a question. Any answer and hint are much appreciated.

I have a table like, 

Type 1	Type 2	Type 3	id
Yes	Yes	Yes	1
No	No	Yes	2
Yes	No	No	3

I want to add a filter on dashboard, which lists 3 values: A, B and C

when I select A, I want to the charts to show Type 2 = Yes. when I select B, I want the records with Type 3 = Yes. When I select C, I want to see all records. How to do this?

Thanks in advance!

[and2022]

Got it. Thank you.

[amitchandak · Accepted solution]

@and2022 , Unpivot the type column in power bi, and create A,B,C  when the type is yes

Or you need to have table with A,b,c as rows, and based on each selection return values

Switch(selectedvalues(Type[Type]),

"A",calculate(Count(Table[id]), filter(Table, Table[Type1] ="Yes")) ,

"B",calculate(Count(Table[id]), filter(Table, Table[Type2] ="Yes")) ,

"C",calculate(Count(Table[id]), filter(Table, Table[Type3] ="Yes"))

)