Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mpicca13
Resolver IV
Resolver IV

Concatenate currency symbol with price and retain conditional formatting

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.

4 REPLIES 4
v-yiruan-msft
Community Support
Community Support

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

Concatenate currency symbol with price and retain conditional formattin.JPG

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.

 

 

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

@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
Skilled Sharer
Skilled Sharer

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
Super User
Super User

@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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.