Customized Format

[BachFel]

Hi there,

is there a possibility to customize the numbers in a visual like for example: 81 abc ?

I´m looking for an equivalent in excel: #.##0,00 "abc"

I´m only able to model the figures in the pre-set formats like currency etc.

Thanks in advance

Felix

[WolfBiber]

Hey,

I Know that this in not exactly what you want, but

you can use a measure like this:

--> create new measure.

--> type

yourMeasure = sum(Table1[Column1]) & "abc"

[BachFel]

Thanks for your suggestion,

but as you mentioned I´m looking for a directly visible unit

[sgsukumaran]

Try using both format and concatenate at the same time

FORMAT(<Value to be formatted>,<Format Pattern>) & " " or  

CONCATENATE(string_expression,CONCATENATE(string_expression,string_expression))

[BachFel]

Not sure how to use your formula.. I´m not into DAX. Does it runs with a new Measure or where is the formala to put in?

[WolfBiber]

Clik right on the left side "Field" and select new Measure, or find button in ribbon menu.

[BachFel]

I did this already. The result is the following:

But my aim was to get the unit within the chart.

[WolfBiber]

Ok, right now there is no built in function in PBI for this.

Check if this can help you:

https://github.com/Microsoft/powerbi-visuals-utils-formattingutils/blob/master/docs/api/value-format...

greetings,

Wolf