Forum Discussion

SabineOussi's avatar
SabineOussi
Icon for Skilled Sharer rankSkilled Sharer
10 years ago
Solved

Dynamic Text

Hello,   Is there a way that I can create a dynamic text within the text box?   In other words, let's say I want to display the following: There are @numberoftickers submitted by @numberofusers ...
Need Help
Tips and Tricks
  • SqlJason's avatar
    SqlJason
    10 years ago

    What you can do is to create a measure like 

    TextMeasure = "There are " +  [numberoftickers] + " submitted by " + [numberofusers] + " and managed by " + [numberofadmins]

     

    Now you can place this measure in a text box and that should show the desired result. Using text based measures is a handy technique in scenarios like this. 

SqlJason's avatar
SqlJason
Icon for Memorable Member rankMemorable Member
10 years ago

What you can do is to create a measure like 

TextMeasure = "There are " +  [numberoftickers] + " submitted by " + [numberofusers] + " and managed by " + [numberofadmins]

 

Now you can place this measure in a text box and that should show the desired result. Using text based measures is a handy technique in scenarios like this. 

  • vaibhav_osc's avatar
    vaibhav_osc
    Icon for Advocate I rankAdvocate I
    9 years ago

    The problem with using a card is that you lose the control over font over individual segments. For eg: if I wanted to display the measure value in bold and different color from rest of the text, or go to next line, I cant do that.

    So basically, being able to concat text and measure directly in text box would be good.

    • TheMayneLine's avatar
      TheMayneLine
      Frequent Visitor
      8 years ago

      The other problem with using a card is that you lose all formating capabilities. (or at least to the best of my knowledge).

       

      I have not been able to left justify the text in a card. 

  • greggyb's avatar
    greggyb
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    SqlJason, & is the concatenation operator in DAX; + is not overloaded as in SQL.

     

    As an additional point, depending on the measure being used to provide the numeric portion of this string, you may find a need for FORMAT(), which allows you to use a format string to alter the display of a numeric or date value.

    • SqlJason's avatar
      SqlJason
      Icon for Memorable Member rankMemorable Member
      10 years ago

      My bad, I forgot to test it before posting :).... Yes you will have to use the & operator as well as FORMAT() based on your needs as greggyb mentioned.

      • SabineOussi's avatar
        SabineOussi
        Icon for Skilled Sharer rankSkilled Sharer
        10 years ago

        Yes, I'm aware about the language, thanks.

         

        I was just hoping to have a more direct solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Chris Webb has blogged about a fantastic solution that listens to slicer values to dynamically create a title.  Very similar solution using a card with no category that "sits on top of" of chart, but a little more robust.

     

  • MAAbdullah_47's avatar
    MAAbdullah_47
    Icon for Helper V rankHelper V
    5 years ago

    Hi But how can we pass it to text ?