change the format of a measure based on a dimension value

[Cobra77]

Hi,

it is possible to change the format of a measure based on a dimension value

Sample with a dimension Type budget and a measure Budget :

Typebudget        Budget

CA                         125000

Marge                    30000

Rate                        15%

CA and Marge whole number, and Rate its percentage.

Thanks

[v-yulgu-msft · Accepted solution]

Hi @Cobra77,

No. It is not possible to format the values under the same column with multiple data types. Otherwise, the data type of this column will be converted into Text.

Regards,

Yuliana Gu

[BobBI]

try this and play around to make it work for you. I added a column

Column = if(Table1[Typebudget]="Rate",FORMAT(Table1[budget]/100,"Percent"),format(Table1[budget],"General Number"))

you might have to use /100 to show 15% instread.

Thanks

SS

[Cobra77]

PBI is live on SSAS Tabular.

When i add column ( its ok , but i ve 21 column like this ;-(  )

but the format is Text ?

And in the matrice of PBI desktop , i have only 1 , in this sample Budget its a mesure, and F_1 your column :

Rate here = 0 , but in reality 0,13 , want 13%

Thanks for your help

[Cobra77]

hi @BobBI

I add measure like  CBT_1_Test:=IF (HASONEVALUE('53 - CBT'[F_1]); VALUES('53 - CBT'[F_1]); BLANK())

its ok .

But how Sum if i ve multiple Affair ?

thanks

[BobBI]

Hi ,

sorry , couldn't quite catch that , what output are you expecting ?

[Cobra77]

hi @BobBI

its the good result , 

but how show thousand separator ?

and how sum or average if i have multiples lines ?

Thanks