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.

[dcresp1]

This one should be simple and would add so much value to every dashboard that I do. Please MS bring this one in to PBI.

[ecooney]

I can't believe that this idea has not been implemented. The inability to conditionally format values with the SWITCH function is a severe limitation on what would otherwise be a very elegant and useful reporting function.

[jmoffett]

Need to add this! This is a key feature for any business intelligence tool.

[tylerhburgess]

Having this would great, allowing the ability to have dynamic measures!

[paresh_p]

This one will give more flexibility

[danmacias13]

This would be extremely helpful, please try and get this one out please.

[Spetter]

Would be awesome! I could use this for enhancing interactivity in reports

[subinthomas]

This has been in request since two years and it is a very basic requirement as we do not have a global variable option too in Power BI. Looking forward to the team to include this flexibility.

[patrick_duffin]

Have any of you tried using the "FORMAT" function? It works.

[fbcideas_migusr]

Would be awesome to have this. Currently, lack of this is a showstopper for using mentioned technique.