Conditional fromatting without 'AND'

[Anonymous]

Hi together,

I want to do a really simple conditional formatting.

If a value is higher than zero I want to show a green circle. If a value is lower than zero I want to show a red circle.

With the conditional formatting rules I always have to configure a 'AND' condition, but I don't want this one.

Does anybody have a better solution for this?

Thank you and regards,

Andreas

[amitchandak · Accepted solution]

@Anonymous , Then you have to color meausre and unichar .

Create a color measure and use that in consitional formatting using field value option

example

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

refer

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

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

Hi @amitchandak ,

thank you for your hint.

I've created a circle with the unichar and then used a meausere with switch() to do the conditional formatting.

Thank you again and best regards,

Andreas