Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Solved! Go to Solution.
Hi @Anonymous,
You could add below measure to card visual.
Measure = SELECTEDVALUE ( Table1[Year] ) & UNICHAR ( 10 ) & SELECTEDVALUE ( Table1[Category] )
Hi @Anonymous,
You could add below measure to card visual.
Measure = SELECTEDVALUE ( Table1[Year] ) & UNICHAR ( 10 ) & SELECTEDVALUE ( Table1[Category] )
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
Thank you. You made my day.
Thanks for the excellent feedback....can you explain what the UNICHAR (10) does so i can learn
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
@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] )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Worked perfectly, Thank you!!
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] )
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.