Forum Discussion
Dynamic use of textboxes
- 4 years ago
Did you know you can layer text boxes graphs, cards and other visuals and then group them ?
For Institution training graph consider adding:-
- A text box = Status:
- A card = to a % measure with red font. In formatting set the catagoty to blank to hide the field name.
- A card = to status measure with conditional formatting for red or navy based on your rules
The click on View > Selection > and group the 3 items
Copy and paste the group over the Community champions and HLF Fellows graph
- 4 years ago
Hi again Sab
A " text box" does what it says on the tin. It displays static text. You can't display a measure in a text box.
Please consider using a card visual instead as I described = to a % measure with a red font. In formatting set the catagoty to blank to hide the field name. The card will look exactly the same as text box and is the best solution to your problem.
If you MUST use a text box (not recommended) then you can use this trick.
Firstly create a measure e.g. Greetings = "Hello Pablo Mazvarira!"
Add a text box, click Tittle On, in Tiitle text click the FX > field value > Greetings.
Then shrink the size of the text box.
In summary, don't use a text box to display a measure. Use a card.
Please click the thumbs up as a thank you for just helping you, and then click resolved if it fixes your problem.
Cheers
Thanks for your response but I see you touched on formatting BUT how do I assign a column value to a textbox ?
Did you click the fx button?