Column format of various data type values

[Anonymous]

Hi guys, I have a column where data types are various (Percentage and General) and the final result is that each KPI will be displayed in a separate Gauge so there is a need to display % sign accordingly to the unit. I tried to create calculated column with IF condition and format percents but the outcome is text  and I can not manupulate these figures. 

Is there a way achieve this through DAX ? Or any other way ?

[MH3]

Hi @wdx223_Daniel ,

your solution seems perfect

[wdx223_Daniel]

@Anonymous could this work

[Anonymous]

@wdx223_Daniel , thanks but the outcome column is text format and it does not suit me 😞

[wdx223_Daniel]

@Anonymous you can try conditional formatting

[MH3]

Hi @Anonymous ,

have you achieved? this problem?

I actually need something like this.

[camargos88]

@Anonymous ,

Have you tried creating 2 measures (1 for % and other for general number) ? First be sure the fact and target columns are numerical.

[Anonymous]

@camargos88 , thanks, will perhaps go with that if there is no other way.