Dynamically change text box or card value

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

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

---

Worked perfectly, Thank you!!

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

---

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