Conditional formatted measures using SWITCH

[matt16]

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 result based on any criteria - it is one single format only. There are valid use cases where you may want to change the format of the SWITCH measure depending on the result. Consider the following SWITCH statement myMeasure = SUMX(MeasureTable,switch([selected measure], 1,[Total Sales], 2,[Total Cost], 3,[Total Margin], 4,[Chg Sales vs LY %] )) The first 3 results are all currency format, but the last result is a percentage format. This currently can't be controlled. I would like to see an optional 3rd parameter in the SWITCH statement to set an alternate number format.

[mstacey]

Any news on this? It's a real pain point. The alternative to this would be a measure picker in the power BI front end - then we could have a measure we could choose from (the latter is my preferred solution)

[mstacey]

Kind of like this: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36082540-measure-picker

[lotta_carlsson8]

Preferably also working from Tabular cube measures and formatting. This is currently a huge disadvantage.

[olga_iatsenko]

Would really help to have this

[brander]

Will be a game changer

[fbcideas_migusr]

This would be helpful to support multiple currencies support as well, since measures using the formatted data are not able to calculate. Are there any alternatives or work around for currency switch?

[pbiideas1]

'+1

[pbiideas1]

Year after years.. Damm why Power BI Team Why.. ?

[nepalidreamX]

Still waiting for this to be implemented, this is a bummer for people who have to create financial reports that have different measures with different data types when using slicer measures

[epuru_sureshbab]

Same here