Forum Discussion
concetenate two measures
Hi All,
I want to concetenate two measures {Measure1 and Measure2} which I have already created. On the report, it should return the value as 'Measure1 - Measure2'. Instead the output shown is in blue color at the top left corner without the measure name on the card. The value is somewhat fixed at the top left corner and does not move from there.
I have given the query for concetenation as -
New Measure = Measure1&" - "&Measure2
Please let me know where I am going wrong.
Thanks!
3 Replies
HI nandix18
Concat_measure = CONCATENATE([Measure1],CONCATENATE(" - ",[Measure1]))
- amitchandak
Super User
nandix18 , do see any image with blue color
do you need New Measure = Measure1 - Measure2
the one you have given will give the text
New Measure = Measure1&" - "&Measure2
- Anand24
Hi nandix18 ,
This happens when you take only one field(be it column or measure) with datatype text in your multi-row card.
Power BI considers it as a categorical value for which multiple KPIs are shown.
What you can do is create a new blank measure/column(measure=" ") and pull it to the values. Now to will just have to hide this new measure's label(disable label or rename it to .(dot) or place a rectangle infront of it or whatever tweak you figure out).
Refer to the below solved community thread from a week ago:
https://community.powerbi.com/t5/Desktop/Indicator-on-a-card/m-p/1297480#M565121
