Dynamic Format for a Measure that contains both numbers and strings

[Mark_C_B]

I have a calculated table that is used in a matrix visualization to display various KPI results.  This table contains a "Value" field that can contain a number, a percentage, or a string.  The dynamic format option seems to be great to help format the matrix columns.  I defined the Value measure and everything works great except for not formating the string portion.

Here is the format section of my Dynamic measure.

SWITCH (
    SELECTEDVALUE ( 'RTGSummary_CM-0'[MetricTrendLabel] ),
    "Corrected Reports", "0",
    "Critical Call Success", IF (SELECTEDVALUE('RTGSummary_CM-0'[Metric Value Decimal])=1.0, "0%", "0.0%" ),
    "Proficiency Testing", "0",
    "Tests Not Performed", "0",
    "Transfusion KPI", IF (SELECTEDVALUE('RTGSummary_CM-0'[Metric Value Decimal])=1.0, "0%", "0.0%" ),
    "TAT KPI Metrics","",
    BLANK()
)

Is this possible to even use a dynamic format measure in this visualization if one of the possible formats is not a number or number variant (%,currency,etc)?

I've searched for this and find lots of help with numeric formats but not string / decimal options, which leads me to believe I can't use this solution in this scenario.

[Daniel29195 · Accepted solution]

@Mark_C_B 

im not sure what you mean . 

check example below : 

is this what you want ? 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠