Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic use of textboxes

  I need a way to dynamically present the above in a PowerBi Viz . My pain point is on the dynamic use of those two textbxes below each visual . I have over 20 visuals but need to figure out h...
  • speedramps's avatar
    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

  • speedramps's avatar
    speedramps
    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