Forum Discussion

Lily_DS's avatar
Lily_DS
Frequent Visitor
3 years ago
Solved

column value based filter

hello    I am building a dashboard contains a filter of companies name i need please hide the other names depends on this filter for example:   table look like: name amount aramco 2001...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Lily_DS 

     

    You can try the following methods.
    Measure:

    Name measure = 
SWITCH(TRUE(),
    SELECTEDVALUE ( Slicer[name] ) = BLANK (),SELECTEDVALUE ( 'Table'[name] ),
    SELECTEDVALUE ( Slicer[name] ) = SELECTEDVALUE ( 'Table'[name] ),SELECTEDVALUE ( 'Table'[name] ),
    "-"
    )

    Is this the result you expect?

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Lily_DS 

 

You can try the following methods.
Measure:

Name measure = 
SWITCH(TRUE(),
    SELECTEDVALUE ( Slicer[name] ) = BLANK (),SELECTEDVALUE ( 'Table'[name] ),
    SELECTEDVALUE ( Slicer[name] ) = SELECTEDVALUE ( 'Table'[name] ),SELECTEDVALUE ( 'Table'[name] ),
    "-"
    )

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • vojtechsima's avatar
    vojtechsima
    Super User
    3 years ago

    v-zhangti ,
    Hello,
    I am not the author of this thread, however, I am interested in this topic, I checked your solution, and it's great.
    You create a new table just for the slicer, I wonder if you can do it within the same table or have a relationship between those two tables.

     
  • Lily_DS's avatar
    Lily_DS
    Frequent Visitor
    3 years ago

    thank you so much ,,  I tryed your solution it's great.🙏