Forum Discussion

XeperRx's avatar
XeperRx
Frequent Visitor
6 years ago
Solved

Custom Card with Color Coding - Customer Payment Rating

Hello All, 

 

I'm really starting to feel comfortable with all of the basic functionallity of PBI, but have just started getting my feet wet with DAX, any help would be greatly appreciated. 

 

I would like to create a custom card that will provide a rating based on customer payment history. I have a column in my data set named Payment Status that defines if invoices were either Late, On-Time, or Open - 

 

 

 

I would like the card to read as follows based off of the Payment Status Column - 

 

# of Late Payments = 0, Excellent/Green 

# of Late Payments = 1-5, Fair/Yellow

# of Late Payments = 6>, Poor/Red
 

  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Maybe:

     

    Measure =
  VAR __Count = COUNTROWS(FILTER('Table',[Payment Status] = "Late"))
RETURN
  SWITCH(TRUE(),
    __Count < 1,"Excellent/Green",
    __Count > 5,"Poor/Red",
    "Fair/Yellow"
  )

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Maybe:

     

    Measure =
  VAR __Count = COUNTROWS(FILTER('Table',[Payment Status] = "Late"))
RETURN
  SWITCH(TRUE(),
    __Count < 1,"Excellent/Green",
    __Count > 5,"Poor/Red",
    "Fair/Yellow"
  )