Forum Discussion

and2022's avatar
and2022
New Member
4 years ago
Solved

How to do make a selection list

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 1Type 2Type 3id
YesYesYes1
NoNoYes2
YesNoNo3

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!

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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"))

    )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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"))

    )