Conditional Format Based on Field Value - Number/Percentage

[stevie_westside]

I am attempting to change my MTD, QTD, YTD values to percentages where appropriate.

I have a dynamic measure that gives me both whole numbers and percentages.  I am trying to figure out how to write a measure that I can apply to the custom formatting function option.

I've gotten as far as:

Dynamic_Format = 
   VAR CurrentValue = SELECTEDMEASURE()
   VAR FormatAsPercent = FORMAT(CurrentValue, "0.00%")
   VAR FormatAsWholeNumber = FORMAT(CurrentValue, "0")
RETURN

???

but I'm not sure where to go from here.  Additionally, my dynamic measure has a slicer attached to it based on this table:

Where I added a DataType column hoping to do something like, IF 1 then FORMAT(as whole number), IF 2 then FORMAT(as decimal), IF 3 then FORMAT(as percentage).... something to that effect.

[Ritaf1983 · Accepted solution]

Hi @stevie_westside 
You can use dynamic string formatting for this goal.

Please refer to my answers in the linked discussions, which include pbix that I created:

https://community.fabric.microsoft.com/t5/Desktop/How-to-dynamically-format-numbers-currency-and-abb...

https://community.fabric.microsoft.com/t5/Desktop/Change-the-currency-symbol-format-for-a-value-colu...

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