Forum Discussion
Conditional colour format on data card
- 6 years ago
Hi Anonymous, this is a multistep process.
- 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" )-
- 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]) )- 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:
-
- Then select the Field Value setting, and select the measure you used - Vs Average in my case.
-
-
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 , You can create a color measure and use that under conditional formatting with field option.
example
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK(Table[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))
Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
icon based
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692