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
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 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.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors