Forum Discussion

infantpowerbi's avatar
infantpowerbi
Icon for Helper II rankHelper II
6 years ago
Solved

Convert the Value into Percentage based on condition

Dear All, I am infant topower bi and facing some challenges due to being new to power bi I am holding data in below format Company        Q2 FY 2018  Q3 FY 2018         Q4 FY 2018  Q1 FY 2019 ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi infantpowerbi ,

    Can you use calculated column? If yes,  you can try the formula below. If not, I think you need to convert the Value column to percentage entirely.

     

    Z Percentage = IF('Table'[Company] = "Z",FORMAT('Table'[Value],"00.00%"))

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

infantpowerbi's avatar
infantpowerbi
Icon for Helper II rankHelper II
6 years ago
Hi,
My client denied to use measure,
So can we convert value column into percentage where company is equal to z
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi infantpowerbi ,

Can you use calculated column? If yes,  you can try the formula below. If not, I think you need to convert the Value column to percentage entirely.

 

Z Percentage = IF('Table'[Company] = "Z",FORMAT('Table'[Value],"00.00%"))

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.