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

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.

nickchobotar's avatar
nickchobotar
Skilled Sharer
8 years ago

ppgandhi11

 

I would suggest you to use a DIVIDE() function with its powerful alternative value feature as a third argument.

 

Percentage =
DIVIDE(
    SUM(Table1[GoodSale]),
    SUM(Table1[TotalSale ]),
    BLANK()  // will return blank if error
)

 

You can set the percentage in the Modeling menu and use conditional formatting for your coloring as Phil_Seamark suggested.

 

Nick  --