Forum Discussion

Jilanibasha's avatar
Jilanibasha
Frequent Visitor
5 years ago
Solved

Concatinate multiple columns in single column

Hi Gurus,   what is the dax formula to display data in below format. Can some one please suggest onthis.     Thanks, Jilani
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Jilanibasha You want UNICHAR(10). So like:

    [Column 1] & UNICHAR(10) & [Column 2] & UNICHAR(10) & ...
v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, Jilanibasha 

According to your description, I can roughly understand your requirement, I think you can use the COMBINEVALUES() to perfectly achieve this:

Measure = COMBINEVALUES(" - ",MAX('Table'[Region]),[Amount1],[percentage1])

 

Then you can create a card visual to place this measure, and you can get what you want.

 

You can download my test pbix file below

More info about the COMBINEVALUES() function in DAX

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.