Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional colour format on data card

Hi there   I have two data cards - one with an average pass ratio, and the other with the pass ratio which changes when you select different slicers. So you can compare the pass ratio alongside the...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    Hi Anonymous, this is a multistep process.

    1. Compute a measure that returns your color selections. I used this:

     

     

    Vs Average = 
VAR varCurrentValue = SELECTEDVALUE('Table'[Value],0)
VAR varAverage = [Average Value]
RETURN
    SWITCH(
        TRUE(),
        varCurrentValue > varAverage, "Green",
        varCurrentValue = varAverage, "Black",
        varCurrentValue < varAverage, "Red"
    )

     

     

      1. So if the current selected value (I used a slicer to select a value) is greater than the Average Value measure, return Green, if equal, black, if below, red. The average value measure is:

     

     

    Average Value = 
CALCULATE(
    AVERAGE('Table'[Value]),
    REMOVEFILTERS('Table'[Category])
)

     

     

    1. Then on the original card, select the label property and change the color from what is probably black to use the fx button conditional format:

      1.  

      2. Then select the Field Value setting, and select the measure you used -  Vs Average in my case.

      3.  

     

    You can see my PBIX here if you want to play with it a bit. You can get rid of my green/red/black text and use hex codes as long as they are in the format "#000000" with the # sign to tweak those colors.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous 

 

You can conditionaly format the background of the card.

and the data label of the card.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes Anonymous I know you can conditionally format the card, my question is, what measure do I use to say if [current value] is greater than [average value] then 'green' else if [current value] is less than [average value] then 'red' else 'black'

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi Anonymous 

     

    I would create a measure which return 1 or 0 and -1 for us, and use it to conditionally format.

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    Anonymous - I included a measure that shows this:

    Vs Average = 
VAR varCurrentValue = SELECTEDVALUE('Table'[Value],0)
VAR varAverage = [Average Value]
RETURN
    SWITCH(
        TRUE(),
        varCurrentValue > varAverage, "Green",
        varCurrentValue = varAverage, "Black",
        varCurrentValue < varAverage, "Red"
    )

    It is not the only way, but a way. Did you download my PBIX file and see how the entire process worked? If it doesn't do what you want, can you be more specific?