Dynamic Formatting of Selected Measure

[sam.mckay]

Hi Mark,

Just a quick one and really simple fix - definitely try to work on formatting the formula a little bit more. It honestly will really help in the long run.

Formula Syntax, Comments & Variables - (1.6) Ultimate Beginners Guide to DAX 2019

Check out this forum post on how to do this

Different formatting types for two switch outcomes

Unfortunately there’s no manual way to do this. You can though wrap certain results in the FORMAT function within the SWITCH statement. Give something like this a try and see if it works for you. FORMAT( [Measures], “0.00%” )

Just need to use FORMAT in the right place.

Chrs