Power BI – Value should be a Currency

-> I was trying to create a new conditional column called “Price Tier” in Power BI based on a Currency column called Price. I got below message,

Value should be a Currency.

-> I couldn’t get much from the internet for this issue.

-> I ended up changing the currency column “Price” to decimal and then created the new conditional column “Price Tier”.

-> Once the new Conditional Column “Price Tier” was created. I changed “Price” back to Currency from Decimal.

-> Not sure if this is a bug, but the workaround actually worked for me.

Thank You,
Vivek Janakiraman

The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Leave a Reply