Forum Discussion

SanjeevMurthy's avatar
SanjeevMurthy
Frequent Visitor
6 years ago
Solved

Different format in Target column

Hi,   I have a field [Target] which has target value for each of the Metric line item. The targets are not in the same data type format. Example Metric 1 - 20% Metric 2 - 2 Metric 3 - 2.5   R...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi SanjeevMurthy ,

    As epappu said, it can be implemented with TEXT type. For now, it is not supported to change different format and stain the original data type except text. 

    I created a measure use the function of IF and FORMAT. You can use it to show the values. When you want to calculate them, you could use the original column. 

    Measure = IF(SELECTEDVALUE('Table'[Metric]) = "Metric1",FORMAT(SUM('Table'[Values]),"00%"),SUM('Table'[Values]))

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi SanjeevMurthy ,

As epappu said, it can be implemented with TEXT type. For now, it is not supported to change different format and stain the original data type except text. 

I created a measure use the function of IF and FORMAT. You can use it to show the values. When you want to calculate them, you could use the original column. 

Measure = IF(SELECTEDVALUE('Table'[Metric]) = "Metric1",FORMAT(SUM('Table'[Values]),"00%"),SUM('Table'[Values]))

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

  • SanjeevMurthy's avatar
    SanjeevMurthy
    Frequent Visitor
    6 years ago

    Thank you all for the suggestions and help. This really helped. Thank you.