Forum Discussion

DaniLP's avatar
DaniLP
New Member
3 years ago
Solved

Conditional format Card value based on the result on another Card

Hi all,    I am unsure if its possible, but i tried looking around and can't seem to find a way.  Im fairly new using and learning on my own pace PowerBI and had to say this so you know my level.....
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Then you will need to create a measure with those filters. 

     

    Create the ones bellow

     

    # Items = 
    --Bellow put the column refering to the items being summed
    SUM('table'[column])


Card 1 Measure = 
    CALCULATE(
        [# Items],
        DATESINPERIOD('Date'[Date], TODAY() , -1000 , DAY )
    )


Card 2 Measure =
    CALCULATE(
        [# Items],
        status[status] in {"Not Started","On Hold","In progress"}
    )

Conditional formating measure = 
VAR _carddiff = [Card 2 Measure] - [Card 1 Measure]

RETURN
IF( _carddiff <> 0, 1, 0)

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Yes, in this case you will need to pass the filters to the measures.

 

Could you share your pbix file so i can provide and example?

DaniLP's avatar
DaniLP
New Member
3 years ago

Can't share the file, but hopefully screens below help:

Card1 filters:

Card2 filters:

same as above+

Card1 is displaying a 5, and Card2 is displaying a 2 in this case.

 

is this enough? thanks 🙂 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Then you will need to create a measure with those filters. 

     

    Create the ones bellow

     

    # Items = 
    --Bellow put the column refering to the items being summed
    SUM('table'[column])


Card 1 Measure = 
    CALCULATE(
        [# Items],
        DATESINPERIOD('Date'[Date], TODAY() , -1000 , DAY )
    )


Card 2 Measure =
    CALCULATE(
        [# Items],
        status[status] in {"Not Started","On Hold","In progress"}
    )

Conditional formating measure = 
VAR _carddiff = [Card 2 Measure] - [Card 1 Measure]

RETURN
IF( _carddiff <> 0, 1, 0)

     

    • DaniLP's avatar
      DaniLP
      New Member
      3 years ago

      thanks, i try replicate the measure, but unsure what part of it makes me get error:

       

      Code below (taken from yours, and adjusted to my table names):

       

      FDSColor = 
    --Bellow put the column refering to the items being summed
    SUM('RICEFW'[FDS Status])


Card 1 Measure = 
    CALCULATE(
        [FDSColor],
        DATESINPERIOD('Date'[Date], TODAY() , -1000 , DAY )
    )


Card 2 Measure =
    CALCULATE(
        [FDSColor],
        RICEFW[FDS Status] in {"Not Started","On Hold","In progress"}
    )

Conditional formating measure = 
VAR _carddiff = [Card 2 Measure] - [Card 1 Measure]

RETURN
IF( _carddiff <> 0, 1, 0)

       

       Is it Card 2 Status part? unsure if i messed up the translation into my table/column name.

       

      I call measure FDS Color because i will have to do this same measure 5x more times for other 5 different types. so wanted to have some easy time to identify each.

       

      Thanks in advance!