Forum Discussion

dineshj23's avatar
dineshj23
Helper I
3 years ago

Conditional Formatting with double values

Hi all,  I have the below data imported into PowerBI. I created dates for each of the sales amounts (Sales 1, 2, 3 etc.) with relationship to the  one main calendar. For the matrix visual, I created...
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi dineshj23 ,

 

You could try creating a measure for conditional formatting.

Color = var _count1=CALCULATE(COUNT('Table'[Saels Order No.]),FILTER(ALLSELECTED('Table'),[Saels Order No.]=MAX('Table'[Saels Order No.])&&[Sales Status]="Approved"))
var _count2=CALCULATE(COUNT('Table'[Saels Order No.]),FILTER(ALLSELECTED('Table'),[Saels Order No.]=MAX('Table'[Saels Order No.])))
return IF(_count1=_count2,"Green")

After the conditional formatting is applied, all must be approved to turn green. The logic is to group according to the sales order number, count the number of "Approved" and the number of sales order numbers, and return green if equal.

 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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