User text input into a measure

[franciscocohen]

Hi all,

I need to get into a measure what an user writes in a report - it could be a text filter, a slicer or any other.

I am able to create a measure that gets a filtered value Measure 1 = SELECTEDVALUE(Table[Column]) but I want my measure to get the text of what was written by the user on the text field.

Is there any solution?

Thanks,

FC.

[djurecicK2]

Hi @franciscocohen ,

 Take a look at the Filter By List visual. I have used it in similar situations. Users can type or cut and paste.

https://appsource.microsoft.com/en-cy/product/power-bi-visuals/devscope-1156626.filterbylist?tab=Ove...

[pi_eye]

Hi @franciscocohen 

If your input parameter is a number, you can try using the option in the modelling ribbon to create a numeric parameter. This creates a field  based on the input that you can add into your report.  See the guidance for "what if analysis" for more information:

However, this is not directly possible for text input (eg words, a name). There are several work arounds in the community for this, but your best option is to maybe look at Power Apps and incorporate that.

Regards,

Pi

[franciscocohen]

Thank you for your reply.

I really need text input.
My final goal is:
I have a report with a text filter.
User can search for something on this textbox and my table visualization gets filtered.

What I want to achieve is that I want to save somewhere everything that my users are searching on my report.

Haven't found any solution so far... 😞

[pi_eye]

I think then, the best option might be an extension as @djurecicK2  has mentioned below or looking at the power Apps. 

I did a quick search to see if this is something that is tracked via the user activtiy or audit logs, but this post seems to suggest it's more complicated than just looking at existing logs:

https://community.powerbi.com/t5/Service/Track-user-activity-What-filter-options-they-are-selecting/...

I actually do think this is something that they should implement - looking at user activity would be extremely useful for us too in informing development.

Pi