Concatenating decimal value column with '%' when a string column contains '%' in it.

To display the '%' symbol beside the percentage value in the "Amount" column whenever the "SubCategory" column contains '%' in it in a Matrix visual, you can use the Power BI DAX (Data Analysis Expressions) language to create a calculated column or measure. Here's a step-by-step guide to achieving this:

1. Open your Power BI file and go to the "Data" view.

2. Create a new calculated column in your data model. To do this, select the "Model" view, find your table, and then right-click on the table. Choose "New Column."

3. Use a DAX formula to create the calculated column. You can use the following formula:

Amount with Percentage = IF(ISNUMBER(SEARCH("%", YourTable[SubCategory])), YourTable[Amount] & "%", YourTable[Amount])

Replace "YourTable" with the name of your table, and "SubCategory" and "Amount" with the actual column names in your table.

The formula checks if the "SubCategory" column contains the '%' symbol. If it does, it appends '%' to the "Amount" value; otherwise, it leaves the "Amount" as it is.

1. Once you've created the calculated column, save your changes and return to the "Visual" view.

2. In the Matrix visual, use the new "Amount with Percentage" column in place of the original "Amount" column. You can drag and drop it into the Values section of the Matrix visual.

Now, your Matrix visual should display the '%' symbol beside the percentage value in the "Amount" column wherever the "SubCategory" column contains '%' in it.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.