How to add Braces to values with Actual value and Delta value In power BI Desktop

[ramshoney1225]

Hi I need to achive the below one, I have a dimension column values and its Measure values.

ex: Colum1, Column2, Column3, Column4 , Measure1 Measure2, Meaure3, Measure 4 as below.

here now i have inculded only one DImension value and remaining measures.

0.13 is actual value ans (0) --> 0 is delta value which both i have calucated and its available straigh away.

The color coding is same for both the values, which i can be taken care.

but the real problem here to me is how can i put both the values side by side  Actualvalue(Deltavalue)  in one column with "()" both the braces added ?

Thanks,

RamsK

[RobbeVL]

Hi there,

You will need to convert your value to text, in able to do this.
Concatenate will help you along 
https://docs.microsoft.com/en-us/dax/concatenate-function-dax 

Also using symbols as "&" will help you put values together in 1 field. (ex. [text1]&" "&[Text2] = text1 Text2 )

Hope this helps.

Robbe

[ramshoney1225]

Hi Robbe,

Thanks for the prompt response, but if i do concatenate then it will become string / text.

so that i wont able to apply color coding to it right ? 😞 

[RobbeVL · Accepted solution]

Hi,

you will still be able to do a conditional formatting.

But you'll probably have to define it in a measure with a SWITCH() function
The bottom example on this link shows you how:
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting 

[Anonymous]

Thanks Robee, its worked everything .

Thanks for the information.