Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Use multiple column names as filter

Requirement :  
Machine Type - LV-Std,LV-Ex,HV-std,HV-ex,product types-IEC,NEMA,Induction,Slipring need as filter selection

this is the sample data

This is how the filter is required

 upon the selection of any one of the value in filter - MT-LV/Std or MT-LV/Ex etc should have "yes" values and the data has to be sliced up based on the city /country having "yes" values .....
 Note : when MT-LV/std has "yes" value ,MT-LV/Ex can have "no" values .

Filter column has to be independant of their selection values.

 

 

Please guide me on the same.

 

What i did was....i unpivoted MT-Lv etc columns independtly  and used calculated column inorder to show the current selected filter value as same value else blank .

But the calculated column is picking up only one selection

Below filter "Selectionidentity" is the table i created .

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Open edit queries, select these columns and unpivot columns

    LV-Std LV-Ex HV-std HV-ex

    Close&&apply, create a measure

    flag = IF(MAX(Sheet2[Value])in {"yes","(yes)"},1,0)

    Add it in the visual level filter

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Is this problem sloved? 

    If it is sloved, could you kindly accept it as a solution to close this case?

    If not, please let me know.

     

    Best Regards

    Maggie