Forum Discussion
Format value to Percentage based on value from another column
hi community folks,
I would like know how we can create a measure to format [KRI] value to % if the column[Metric_Type] = Percentage, else don't change the format.
| Metric_Type | KRI | (expected outcome) |
Number | 9 | 9 |
| Percentage | 1 | 100% |
| Percentage | 0.95 | 95% |
| Number | 1 | 1 |
Any advise and help is greatly appreciated.
1 Reply
- amitchandak
Super User
kimloh_p , I doubt that.
You can use format , but that will make output as text
refer: https://radacad.com/dynamically-change-the-format-of-values-in-power-bi
