MATRIX formatting with mixed data types

Hi, mrothschild 

I am glad to help you.   

According to your description, you want to know how can you format the Matrix to show the data in 0.00% format? 

If I understand you correctly, then you can refer to my solution.  

In your Measure, you might consider adding a judgment to convert data that can be converted to a percentage to a percentage. 

You can refer to my Measure formula, I hope it helps you: 

zzMarked_LRF_Text1 = 
IF (
    ISFILTERED ( 'Fund I Investment Schedule'[Project] ),
    VAR value_ =
        VALUES ( 'Fund I Investment Schedule'[Marked LRF] )
    RETURN
        IF (
            ISERROR ( VALUE ( value_ ) ),
            value_,
            FORMAT ( VALUE ( value_ ), "0.00%" )
        ),
    BLANK ()
)

Here is my test result: 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

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