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
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
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
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You say to "add a measure" to the visualization but you don't say how to do it.

    v-yulgu-msft wrote:

    Hi Anonymous,

     

    You could add below measure to card visual.

    Measure =
SELECTEDVALUE ( Table1[Year] ) & UNICHAR ( 10 )
    & SELECTEDVALUE ( Table1[Category] )
    Best regards,
    Yuliana Gu

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you. You made my day. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the excellent feedback....can you explain what the UNICHAR (10) does so i can learn