Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Column format of various data type values

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 ?

Need Help

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

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

  • MH3's avatar
    MH3
    Icon for Helper V rankHelper V
    5 years ago

    Hi Anonymous ,

     

    have you achieved? this problem?

     

    I actually need something like this.