Forum Discussion
Conditional Format showing wrong results
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.
and applyed conditional format on top of it. Even it didn't work. Kindly help me with the requirement.
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
4 Replies
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
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
