Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Show unselected values

Is there any way to show the unselected values from the slicer in a seperate visual? 
So in the below example I would like to show Florida, Nevada and Texas in a seperate visual. Is this possible?

Please find the sample pbix file here

 

 

Thanks in advance

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Hi Anonymous

     

    One way could be to create a Calculated Table with single column states

    From Modelling Tab>>New Table

     

    States = VALUES(Table2[State])

    Then we can use this MEASURE and use it as a visual filter

    Please see attached file

     

    Measure = if(SELECTEDVALUE(States[State]) in VALUES(Table2[State]),1,0)

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Hi Anonymous

     

    One way could be to create a Calculated Table with single column states

    From Modelling Tab>>New Table

     

    States = VALUES(Table2[State])

    Then we can use this MEASURE and use it as a visual filter

    Please see attached file

     

    Measure = if(SELECTEDVALUE(States[State]) in VALUES(Table2[State]),1,0)