Conditional formatted measures using SWITCH
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],
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.
This would be extremely helpful, please try and get this one out please.
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.
Would be awesome! I could use this for enhancing interactivity in reports
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.
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.
Paresh Patel commented
This one will give more flexibility
This one is so simple but would make my dashboard formatting SO much better. Please MS take a look at this much-needed improvement.
Need to add this! This is a key feature for any business intelligence tool.
Tyler Burgess commented
Having this would great, allowing the ability to have dynamic measures!
Sean Cupolo commented
Would truly add some flexible functionality. I have a matrix that has multiple measures that are inter-related (QTY, Unit Rate, Hours, Unit Price, etc. Putting them all on a matrix at the same time is confusing for the end user. Adding a slicer to select the measures that the user wants to see makes for a valuable analytic. Using Switch is the only current option. However, a better option would be to just build the functionality into the matrix and slicer essentially building a field filter.
Power Bi has so many nice features, please add this it will be very helpful
Paul Turley commented
I've encountered this as well. I klugy work around is to return a formatted string for the measure. Not an ideal solution, I admit.
Colin Banfield commented
Mixing program logic with presentation logic is not a good idea. Since SWICH is syntax sugar for nested IFs, it is equivalent to adding a number format parameter to an IF statement. SWITCH is not the right place for setting conditional number formats. The correct place is in conditional formatting. At the time of this comment, Excel has had the capability for ten years.
Common problem and very important. Please add this!
We also need Custom Number format. So that we can use our own number formats just like excel.
Mark Stacey commented
This is also needed for multi currency, which is possibly a more common scenario
Common problem and very important. Please add this.
Hector Villafuerte commented
It is possible to show different formats in the same column for a TableMatrix as shown below. In a Matrix use the formatting Values option "Show in Rows".
It would be great if this could get some more votes. It is a really necessary change that would greatly assist with formatting in visuals. Please support this one so that we can get Microsoft to look at this.
Jörg Tiedemann commented
It's a necessary thing that I need and it would solve a problem that I have often.