Forum Discussion
Using Text Filter to show filtered data
Hi All -
I have huge of dataset of purchases, and want to share to users but only based on their Request no.
I am thinking to use text filter in empty page then when they fill the request no in text filter, it will show the results based on the request number input.
is it possible?
Thanks
rezaaditia , you have create all measure like
new measure = if(isfiltered(Text[text]),[Measure] ,blank())
all measures need to consider if the text is filtered
also, refer for text filter
https://exceleratorbi.com.au/text-filtering-power-bi/
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview
2 Replies
- amitchandakSuper User
rezaaditia , you have create all measure like
new measure = if(isfiltered(Text[text]),[Measure] ,blank())
all measures need to consider if the text is filtered
also, refer for text filter
https://exceleratorbi.com.au/text-filtering-power-bi/
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview
- AnonymousNot applicable
Hi rezaaditia,
I'd like to suggest you configure the RLS filter based username, you can setting a user table to mapping username with request-id.
RLS with UserName()
Regards,Xiaoxin Sheng