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

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.

    • DOLEARY85's avatar
      DOLEARY85
      Resident Rockstar
      3 years ago

      I believe due to the different formats you want within a single column it will need to be a measure.