cancel
Showing results for
Did you mean:
Post Prodigy

## Concatentate on one line...

Hi Experts

is it possible to show the following measure on online as x (y) as oppsoed to being stack in a card..

`Test = CONCATENATE(DIVIDE([Local Margin]-[Budget Sales GM Reported AOP],[Budget Sales GM Reported AOP],0), CONCATENATE(" ",[Local Margin]-[Budget Sales GM Reported AOP]))`
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

## Re: Concatentate on one line...

Hi @Route11

As tested, when using "concatenate" function to connect two column, but the result can't show the data type you set for the original columns.

Best Regards

Maggie

5 REPLIES 5
Post Prodigy

## Show both % and £m value by using concatenate in a measure

Hi Experts

Is it possible to show teo financial values when using a measure in the same measure when using the concatenate function wrapped around the initial measure....if this makes sense...

so i have

`GMvPY2% (Reported AOP) = DIVIDE([Local Margin]-[Budget Sales GM Reported AOP],[Budget Sales GM Reported AOP],0)`

which Shows current 3.02% on the bar chart....BUT i want to show £34.3m (3.02%).

Super User IV

## Re: Concatentate on one line...

Can you provide a picture of what you are seeing with this? Also, some sample data would help to recreate. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

Post Prodigy

## Re: Concatentate on one line...

Greg see image...would like to show 21.37% and 5.2M

Community Support

## Re: Concatentate on one line...

Hi @Route11

As tested, when using "concatenate" function to connect two column, but the result can't show the data type you set for the original columns.

Best Regards

Maggie

Post Prodigy

## Re: Concatentate on one line...

thanks maggie.. thats what i ended up doing. appreciated the feedback

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors