cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JayTG123
Advocate I
Advocate I

Filter to show users what they have searched in the Microsoft Text Filter Visual

Hi all,

 

I am trying to think of the DAX measure requried to show users on the report header what they have entered in on the Microsoft Text Filter Visual. 

Screenshot below shows the text filter visual and this search is looks at this column on the report: 

Street Works Applications & Works'[work_reference_number]
 
So for example if I search for GE401 this will show me all work references thats have the GE401 heading. It works fine but I am looking for a header to go at the top of the report to show users what they have searched for - when the filter pane is closed. 

Also is there anyway this can be capitcalised as well ? so for example if a user searched for ge401 the heading will show as GE401.

Any help is appreciated - many thanks!

Jay

 

JayTG123_0-1642685867240.png

 

1 ACCEPTED SOLUTION
othy_bi
Post Prodigy
Post Prodigy

Hi @JayTG123 

You can not retrieve whatever value was written in a Text Filter visual.

For example, if a user searched for GE you will not be able to display this value somewhere in report or through a measure otherwise what you can display is all values which contain GE.

 

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

View solution in original post

2 REPLIES 2
JayTG123
Advocate I
Advocate I

Hi @othy_bi thank you!! No probs, but appreciate the response.

Jay

othy_bi
Post Prodigy
Post Prodigy

Hi @JayTG123 

You can not retrieve whatever value was written in a Text Filter visual.

For example, if a user searched for GE you will not be able to display this value somewhere in report or through a measure otherwise what you can display is all values which contain GE.

 

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors