Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Using a value for multiple different filters (selecting just one filter) - dynamically switch

Hi everyone!   I have a satisfaction survey comparing some years (2017, 2016, 2015...)   Then I have a column with a lot of different departments like: "A"; "B"; "C"; "D"...   The problem is th...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    1.Create a new table with only one column from your "survey" table

    Table = FILTER(VALUES(Sheet7[department]),[department]<>"EF")

    Then add this column in the new table to a default slicer .

     

    2. create two measures

    Measure = SELECTEDVALUE('Table'[department])

Measure 2 = IF([Measure]=MAX([department]),1,IF([Measure]="A"||[Measure]="B",IF(MAX([department])="EF",1,0)))

     

    3. add Measure2 in the Visual level filter

    select "show values when item is" 1

     

     

    Best Regards

    Maggie

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

Hi Anonymous

1.Create a new table with only one column from your "survey" table

Table = FILTER(VALUES(Sheet7[department]),[department]<>"EF")

Then add this column in the new table to a default slicer .

 

2. create two measures

Measure = SELECTEDVALUE('Table'[department])

Measure 2 = IF([Measure]=MAX([department]),1,IF([Measure]="A"||[Measure]="B",IF(MAX([department])="EF",1,0)))

 

3. add Measure2 in the Visual level filter

select "show values when item is" 1

 

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Oh! thank you very much v-juanli-msft it really works!

    dedelman_clng Sorry for the late reply, was trying to understand the method hehe. Now i'm with new knowledges!