A current limitation in Power BI SWITCH measures (and all Power Pivot actually) is that a SWITCH measure must have a single format. It is currently not possible to conditionally format the measure r...
Please add a feature in Power BI to fix this problem. I want to make my data currency with 0 decimals if $ is selected in a slicer but currency with 2 decimals if $ per widget is selected in the slicer. In order for a Matrix to automatically filter out Nulls, the format needs to be in a number format (Not Text).
