Forum Discussion
Conditional fromatting without 'AND'
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
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/811692To 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.
2 Replies
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/811692To 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.
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