Show conditional formatting icons only in one of the columns in a matrix table

[jpsf]

Hi,

I'm trying to show conditional formatting icons only in the last column in a matrix table (icons only, numeric values, but in the Value column there are text and numbers). If I apply the conditional formatting to the entire table, other values in other columns are affected (the values disappear). I also have conditional formatting applied to certain values that only appear in two of the columns (see screenshot), affecting background and font colors.

I have been searching for possible solutions instead of conditional formatting, for example replacing the numerical values for this attribute in the table by unicode characters (I need to replace specific values for red, yellow or green circles (0 for red, 0.1. for red, 0.2 for red, 0.3 for red, 0.4 for red, 0.5 for yellow, 0.6 for yellow, 0.7 for yellow, 0.8 for green, 0.9 for green and 1 for green) but if I replace the values by unichar(code) it doesn't show automatically in the visual for example:

🟠 128992

🟡 128993

🟢 128994

Any help?

Thanks

[jpsf]

Thanks for the help Tharun!
If I add a measure, I will get a subdivision of the columns right, with the measure showing in each, besides the Value? I want to keep the structure of the columns as shown above.

[tharunkumarRTK]

@jpsf 

You can use dynamic format strings

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings

Include your logic in the dynamic format string expression, and include unichar symbols where needed. Refer the link provided above. 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[jpsf]

Thanks Tharun for the help! If I add a measure, I will get the existing columns subdivided in two, the Value column and the Measure column, right? I want to keep the structure of the table as above.

[jpsf]

Hi tarun, thanks for helping. If I use a measure as a second item in the visual as value, I will have the columns subdivided in two. I want to keep the structure of the visual, is it possible by adding a measure?

[tharunkumarRTK]

@jpsf 

I suggested you to add the measure for debugging purposes. Once you fix all the measures then you dont need to keep the measure in the visual. 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[jpsf]

Yes but I want to show the "traffic light" in the last column like in the screenshot below. I found an alternative, with font color white for the values in the last column that I don't want to show. The problem is the indentation is not manageable like this in all columns as powerbi can only position the icons on the left or right of the data.

[tharunkumarRTK]

Ok, if you want to go with this approach and indentation is the only problem then 
you can out Unichar 127, which can add printable space character and that should solve your problem.

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!