Conditional Format showing wrong results

[Anonymous]

Hi Community,

Need your help here. I am having a Total amount, One of the numeric field. I want to apply Conditional Format with Back ground Color on it.

The Requement here is when ever the total of the month is less than 3% of Sum of Year ( 19627.88) i need to get Red. 3% to 6% Yellow and (>6% )remaining to Green,
I tried applying "show as a percentage of grand total" option in field value and applied conditional format on top of it its showing wrong results as shown in image below 

I tried creating a DAX measure to it in order to acheive results but its showing wrong back ground color.

% total = DIVIDE(SUM(SalesOrders[Total]),CALCULATE( Sum(SalesOrders[Total]),ALL(SalesOrders)))

and applyed conditional format on top of it. Even it didn't work. Kindly help me with the requirement.

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

%GT Total =
var _total=SUMX(ALL('Table'),'Table'[amount])
var _group=MAX('Table'[amount])
return
IF(HASONEVALUE('Table'[date]),
DIVIDE(_group,_total),DIVIDE(_total,_total))

format =
SWITCH(
    TRUE(),
    [%GT Total] <=0.03,"red",
    [%GT Total]>0.03&&[%GT Total]<=0.06,"yellow",
    "green")

2. Click Format – Conditional formatting – select [%GT Total] – Background color – Advanced controls.

3. Enter the Background color interface.

Format style – Field value.

4. Result:

Best Regards,

Liu Yang

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

[Anonymous]

@v-yangliu-msft  Issue got resoled Thanks.

[Anonymous]

@amitchandak 
Even It didn't Work 

[amitchandak]

@Anonymous , Use Number, in place percent, after 0 and 3. and all other lines

Also, % is ratio here so it will be between 0 to 1.  like 0 to .03