Forum Discussion

phuocnguyen's avatar
phuocnguyen
Frequent Visitor
4 years ago
Solved

Create dynamic table based on text filter values

Hi guys, i need felp for this: As you can see I have a TEXT FILTER and TABLE displayed below: What I need here is to hide all the values in the table as the first sight, user can only see the...
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi phuocnguyen ,

     

    You can try below steps:-

     

    1. Create a seperate table with below code:-

     

     

    Table = DISTINCT(Sheet1[OrigSalesId])

     

     

    2. Use newly created table column in the search text visual.

    3. Now Create a measure with below code and use it as filter on your table visual:-

     

     

    _filter =
IF (
    MAX ( Sheet1[OrigSalesId] ) = SELECTEDVALUE ( 'Table'[OrigSalesId] ),
    1,
    0
)

     

     

     

    Below is your file for your reference:-

     

     https://file.io/hLllhowC6hjc

     

    Thanks,

    Samarth

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi phuocnguyen 

 

did you add the OrigsalesId column to the field of Text filter visual.

 

 

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/