Forum Discussion
Hopeful question
Hi all
Hoping you might have a definitive answer for this one.
My client has asked if it is possible to use text to determine what visuals are shown in the report. I am aware of the 'Text Filter' visual and how it can filter out specific data in various visuals, however in this instance it would be to determine what visuals are on display in the report itself.
For example in my report if I had 4 separate cards with the following:
- Orange Sales - 50
- Apple sales - 80
- Orange price - £0.45
- Apple price - £0.30
Is it possible to manipulate the 'Text Filter' visual in such a way that if my user typed in 'Orange' (for example), that either a bookmark, or other solution, triggers to show only cards 1 and 3 in this instance, whilst hiding cards 2 and 4.
A hopeful one, but interested to see any responses.
Thanks all.
Hi Anonymous ,
I updated my sample pbix file, you can get it from this link. The updated information as below:
1. Add a Text Filter visual
2. Create a measure as below and create two mask cards used this measure
Message = IF( ISFILTERED('Fruits'[Fruit]), "", "You must input any value in text filter to see the results" )3. Create a measure to display or hidden the cards and format the background color of mask cards with this measure
Make Transparent = IF( ISFILTERED('Fruits'[Fruit]), "#FFFFFF00", "White" )Best Regards
Rena
9 Replies
Hi, Anonymous , I think here's a solution to your issue, pls refer to this old post,
https://community.powerbi.com/t5/Desktop/Bookmark-on-slicer-selection/td-p/307164
Hi CNENFRNL
Thansk for taking the time to respond. Indeed, that thread came up when I was searching for answers to this particular problem.
That thread talks about data in tables, whereas my query revolves around the visibility of the card visual.
Appreciate you responding though 🙂
