Create dynamic table based on text filter values

[phuocnguyen]

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 values by typing what they need in the search box).

[Samarth_18 · Accepted solution]

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]

Thank you, this work well for me.

[phuocnguyen]

Hi @Samarth_18 ,

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

[Samarth_18]

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

[VahidDM]

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/

[phuocnguyen]

Dear @VahidDM ,

Yes it is

[VahidDM]

Can you share your PBIX file?

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[phuocnguyen]

Sure @VahidDM 

Please use this link:

https://drive.google.com/file/d/1ARRsaCmksZjzdLOtC9se07uJdxYQ64Nf/view?usp=sharing