Forum Discussion
Solved
Power BI table Desktop
I have table in Power BI having two columns. I need want show 0.31 as 31% which is 0.31 multiply by hundred and add % at last for only for values stock tank B2 (EUC) and Stock tank C(Res/ARS) like ...
- Hi,try this measure:Value Measure For Multiple Data Formats = IF(OR(CONTAINSSTRING(SELECTEDVALUE('TableName'[Tag_Description]),"(Euc)"),CONTAINSSTRING(SELECTEDVALUE('TableName'[Tag_Description]),"(Res/ARS)")),FORMAT(SUM('TableName'[Value])/100,"Percent"),FORMAT(SUM('TableName'[Value]),"#"))
Sorry change the last part of the measure ,"#")) to ,"0.00")) for decimal
Without seeing more of what is in the file it's going to be difficult to tell why that's happening. Have you got a copy of the PBI file i can take a look at?
This measure is working fine now. Thanks a Lot. How to do as New column without the measure. Is it Possible.
I believe due to the different formats you want within a single column it will need to be a measure.