Forum Discussion

ACraig08's avatar
ACraig08
Icon for Helper III rankHelper III
2 years ago
Solved

Conditional Dynamic Value in Text Box

Hello! So you know how you can add a dynamic value inside of a text box: I have been trying to find anything that provides documentation or a video tutorial on how to use this but nothing.  I...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ACraig08 

     

    I suggest that you can put the results you want into a card visual.

    DAX:

    Measure = SELECTEDVALUE('Table'[Project count])&"  added in  "&SELECTEDVALUE('Table'[District])

     

    Result:

     

     

    At the same time, you can also modify the format of the card visual.

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
2 years ago

ACraig08 

I think this will give you what you are looking for.

 

Concat = 
CONCATENATEX (
    'Added Project Count',
		CALCULATE ( SELECTEDVALUE ( 'Added Project Count'[Project Count] ) ) & 
		" added in " &
		CALCULATE ( SELECTEDVALUE ( 'Added Project Count'[District] ) ),
    UNICHAR ( 10 ),
    CALCULATE ( SELECTEDVALUE ( 'Added Project Count'[District] ) )
)

 

 

 

  • ACraig08's avatar
    ACraig08
    Icon for Helper III rankHelper III
    2 years ago

    So is there no way to do it within the "Ask a question about your data" box so it's one district at a time and I can edit the formatting. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi ACraig08 

       

      I suggest that you can put the results you want into a card visual.

      DAX:

      Measure = SELECTEDVALUE('Table'[Project count])&"  added in  "&SELECTEDVALUE('Table'[District])

       

      Result:

       

       

      At the same time, you can also modify the format of the card visual.

       

       

       

       

       

       

      Best Regards,

      Jayleny

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.