Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello experts,
My raw data is following
Category | Account Description |
CAT1 | Clng Contract-Fix |
CAT1 | Clng Contract-Var |
CAT1 | Clng Contract - AbcAbcde Abcdef |
CAT1 | Walk - Abc Abcd-Fix |
CAT1 | Clng Contract - AbcAbcde AB |
CAT1 | Walk - Off Mats Sourced |
CAT1 | Walk - Off Mats-Var |
I have written a measure as following
Measure =
"Higher" & UNICHAR ( 10 ) & "{"
& UNICHAR ( 10 )
& CONCATENATEX ( t1, [Account Description], "," & UNICHAR ( 10 ) )
& UNICHAR ( 10 ) & "}"
When I display this measure on a card visual I get following
How can I edit the measure for the card visual to generate the output as below
Higher
{
Clng Contract-Fix,
Clng Contract-Var,
Clng Contract - AbcAbcde Abcdef,
Walk - Abc Abcd-Fix,
Clng Contract - AbcAbcde AB,
Walk - Off Mats Sourced,
Walk - Off Mats-Var
}
Thank you in advance.
Solved! Go to Solution.
@V-pazhen-msftthanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
81 | |
70 | |
61 |
User | Count |
---|---|
148 | |
116 | |
104 | |
89 | |
65 |