Forum Discussion

ppgandhi11's avatar
ppgandhi11
Helper V
8 years ago
Solved

Counting Percentage problem.

Hi, I am very new to power bi. trying to get hold on the functionalities. I have following dataset.   Customer  TotalSale  GoodSale ABC             120           90 DEF             200           ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    The conditional formatting features don't currently support using measurse to determine the back/font colur.

     

    You can use the code to generate arrows or other characters (thumbs up/down etc).

     

    Let me know if you'd like help with that.

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI ppgandhi11

 

Why not just add another calculated column using your formula.

 

new column = 'table'[GoodSale] * 100 / 'table'[TotalSale]