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

phuocnguyen's avatar
phuocnguyen
Frequent Visitor
4 years ago

Hi Samarth_18 ,

Thank you for your instruction, but the file has been deleted, could you check it again?

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

phuocnguyen ,Please check your Private message. I have sent you updated url.