Skip to main content

Power BI

Needs Votes

Add Additional Number Format Options

Vote (4) Share
Matthew Farrow's profile image

Matthew Farrow on 20 May 2019 21:26:14

It would be great to have a few additional number formatting options. For dates for instance it would be useful to have DD MMM YY or various other combos of this.

Also, I have been building cards to highlight variance. It would be great if there were number formatting options to include + as well as - values for numbers. For instance, I may want to show +£250 rather than just £250. Combined with conditional formatting this would make changes clear at a quick glance (e.g. a red +£250 would be an increase on something we want to go down). I know you can format numbers using FORMAT () and custom number formatting, however, when I do this multi card visuals recognise these numbers as card titles

Comments (1)
Matthew Farrow's profile image Profile Picture

Joris Bolder on 16 Apr 2024 09:23:55

RE: Add Additional Number Format Options

I'm sspecially missing the option for a '+' in front of positive numbers. Because when I customize this with FORMAT() dax, the measure can't be used anymore for graphs and other measures, so you end up making unnecessary duplicates. Like 'Measure = "+" & IdenticalMeasure'.