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

Rajeshcric424's avatar
Rajeshcric424
Frequent Visitor
3 years ago

 Thanks for your help, I am new to Power BI in learning phase. I have tried the measure but it showing the out as 0.31% and 0.12%  not as 31% and 12%.

  • 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