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

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