Change FORMAT in Dax

[cristianml]

Hi,

I want to change the format in dax using FORMAT fuction but is not working :

VAR _3 = FORMAT([_Actual + Backlog CI %],"0%")

Could you help me to identify the cause ?

[amitchandak · Accepted solution]

@cristianml , You should format all three so that you get a text from all three.

You can also explore calculation groups

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

[PC2790 · Accepted solution]

Hi @cristianml ,

Check first if the measure - [_Actual + Backlog  CI%] is giving you any result. Looks like youare trying to add a number to a percentage value.

You can also try:

DIVIDE(Numerator,Denominator) and the in the Measure Formatting Tools, formatting it to a percentage value.

[cristianml]

Hi @PC2790 ,

The measures works fine. No problema with that. se below:

The problem is that I need to change the format but with FORMAT Funcion is not working:

Without FORMAT:

With FORMAT:

Same with Tabular Editor:

[PC2790]

Hey @cristianml ,

For future, can you elaborate what turned out to be the issue?

Is it because the percentage value is going out of range of the graph?

[amitchandak · Accepted solution]

@cristianml , You should format all three so that you get a text from all three.

You can also explore calculation groups

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

[cristianml]

Hi @amitchandak ,

I tryed but still not working. I need to change it to percent format, only the 3rd Var

with FORMAT :

Also I use same measure in visual but not sure why are showing different format. Even if the Format is in %