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
Super 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

    Hi Anonymous 

       I think you can create 2 Measures based on the slicer secltion and use them in Multirow card.

     

    Measure1 = SELECTEDVALUE (Table1[Year])

    Measur 2 = SELECTEDVALUE( Table1[Category]).

     

    Place them in the Multirow card to get the desired result. You can do little bit of formatting like removing header etc.

     

    Thanks
    Raj

  • 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] )

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Worked perfectly, Thank you!!