Concatenate currency symbol with price and retain conditional formatting

[mpicca13]

I have a fact table which contains 2 columns, selling price(Currency Type) and Currency (String).

currency can either be (USD, CAD, MXN).

Is it possible with DAX to concatenate the two and still retain conditional formatting in a matrix for price ranges?

I would like to do this without further normalizing into a seperate dim_currency table.

[v-yiruan-msft]

Hi @mpicca13 ,

You can follow the below steps to achieve it, you can find the details in below screenshot:

1. Create a measure to set the color by conditions base on field [Selling price]

2. Create a measure or calculated column to concatenate the field [Selling price] and [Currency]

Concatenate = CONCATENATE(CONCATENATE('Table'[Currency]," "),'Table'[Selling price])//calculated column​

Measure= CONCATENATE(CONCATENATE(MAX('Table'[Currency])," "),MAX('Table'[Selling price]))

3. Set the conditional formatting for the concatenate field use the conditional formatting measure

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[mpicca13]

@v-yiruan-msft Thank you for the suggestions. Calculated columns are not an option here, that dataset is too large. I've tried with the  easure as you suggested but the performance is very bad. Resulted in Dax timing of 37,000 MS.

[anandav]

You can use Condition Formatting based on the Currency field for the new concatenated field.

Not sure whether this is what you are after or I am not getting your requirement.

[amitchandak]

@mpicca13 , if you append like a text then it will become text. You can not do numeric operations after that. If possible keep the currency column in a separate column. If there is a single currency then you can use option under format in Measure/column tools