Dynamically change text box or card value

[Anonymous]

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. AOP or PY
So if user select from first slicer 2017 and the AOP from 2nd slicer then in card or text box show

2017
AOP
On two lines.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

You could add below measure to card visual.

Measure =
SELECTEDVALUE ( Table1[Year] ) & UNICHAR ( 10 )
    & SELECTEDVALUE ( Table1[Category] )

Best regards,

Yuliana Gu

[Anonymous]

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]

Thank you. You made my day. 

[Anonymous]

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

[v-yulgu-msft]

Hi @Anonymous,

UNICHAR function returns the Unicode character referenced by the numeric value. unichar(10) returns a unicode in your measure, and it is recognised by a text. Here are some links for you to better understand its usage.

DAX UNICHAR Function in Power BI

Concatenate text with newlines in Power BI

Best regards,

Yuliana Gu

[parry2k]

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

[nancmadi]

Worked perfectly, Thank you!!

[Anonymous]

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

---

[rajendran]

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