Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamically change text box or card value

Hi Experts How would you dynamically change the value in a card or text box based on the election made in two slicers. 1. Slicer options are. Year either 2017, 2018 Dec 2. Slicer options are. A...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    You could add below measure to card visual.

    Measure =
SELECTEDVALUE ( Table1[Year] ) & UNICHAR ( 10 )
    & SELECTEDVALUE ( Table1[Category] )
    Best regards,
    Yuliana Gu
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous not sure about the two lines of code but you can create measure to combine values from the slicers:

 

Selected Slicer Value = 
SELECTEDVALUE( Table1[Slicer1] ) & " "  & 
SELECTEDVALUE( Table1[Slicer2] )
Anonymous's avatar
Anonymous
Not applicable
7 years ago

How do you put a measure into a text box? I can only type in text. 

parry2k wrote:

Anonymousnot sure about the two lines of code but you can create measure to combine values from the slicers:

 

Selected Slicer Value = 
SELECTEDVALUE( Table1[Slicer1] ) & " "  & 
SELECTEDVALUE( Table1[Slicer2] )