Forum Discussion
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]))Hi Anonymous
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.
As a workaround, you could add a column in the "toolip" field to show more information as you wanted.
Best Regards
Maggie
5 Replies
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%).
- Greg_Deckler
Community Champion
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
v-juanli-msftCommunity Support
Hi Anonymous
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.
As a workaround, you could add a column in the "toolip" field to show more information as you wanted.
Best Regards
Maggie
