topic Re: Column format of various data type values in DAX Commands and Tips

Column format of various data type values

Anonymous — Fri, 04 Dec 2020 07:55:24 GMT

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 ?

Re: Column format of various data type values

camargos88 — Fri, 04 Dec 2020 12:00:35 GMT

Anonymous ,

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

Re: Column format of various data type values

MH3 — Mon, 07 Dec 2020 06:35:40 GMT

Hi Anonymous ,

have you achieved? this problem?

I actually need something like this.

Re: Column format of various data type values

wdx223_Daniel — Mon, 07 Dec 2020 08:22:02 GMT

Anonymous could this work

Re: Column format of various data type values

Anonymous — Mon, 07 Dec 2020 09:22:39 GMT

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

Re: Column format of various data type values

Anonymous — Mon, 07 Dec 2020 09:23:37 GMT

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

Re: Column format of various data type values

MH3 — Mon, 07 Dec 2020 09:26:27 GMT

Hi wdx223_Daniel ,

your solution seems perfect

Re: Column format of various data type values

wdx223_Daniel — Mon, 07 Dec 2020 14:25:56 GMT

Anonymous you can try conditional formatting