Forum Discussion

Rajeshcric424's avatar
Rajeshcric424
Frequent Visitor
3 years ago
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 ...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago
    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]),"#"))
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Sorry change the last part of the measure ,"#")) to ,"0.00")) for decimal

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago
Try removing the /100 part of the measure, that should give you 31.00% & 12.00%:
 
Value Measure For Multiple Data Formats = IF(OR(CONTAINSSTRING(SELECTEDVALUE('Table'[Tag_Description]),"(Euc)"),CONTAINSSTRING(SELECTEDVALUE('Table'[Tag_Description]),"(Res/ARS)")),FORMAT(SUM('Table (3)'[Value]),"Percent"),FORMAT(SUM('Table (3)'[Value]),"0.00"))
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Also if you don't want the .00 after the percentage you can change "percent" to "0%" full measure below:

 

Value Measure For Multiple Data Formats = IF(OR(CONTAINSSTRING(SELECTEDVALUE('Table'[Tag_Description]),"(Euc)"),CONTAINSSTRING(SELECTEDVALUE('Table'[Tag_Description]),"(Res/ARS)")),FORMAT(SUM('Table'[Value]),"0%"),FORMAT(SUM('Table'[Value]),"0.00"))
  • Rajeshcric424's avatar
    Rajeshcric424
    Frequent Visitor
    3 years ago

    Hi This is measure is working good showing values 31% and 12%. but all the values are showing empty. 

     

    In my table ther are only five stock tank B2 but all the others it is showing as Stocktank B2 and empty. same for values taking for all the columns after applying the measure

     

    example:

    there five rows in table one row is stock tank B2 . it chnage the value for 31% for paticular rows. it shwoing five rows with stcok tank B2 and one 31% others empty

    • DOLEARY85's avatar
      DOLEARY85
      Resident Rockstar
      3 years ago

      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?

      • Rajeshcric424's avatar
        Rajeshcric424
        Frequent Visitor
        3 years ago

        This measure is working fine now. Thanks a Lot. How to do as New column without the measure. Is it Possible.