Forum Discussion
Excel base condition
Hi All, Currently, I am making condition formating on excel but later I am going to apply similer to Power BI. I unsolve and solved picture which I am looking for. I want to use color condition. U...
Anonymous , not very clear. But you can use color measures. Here based on multiple conditions you return to color and then use that color measure in conditional formatting of a column/s using the field value option
color value example
Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")
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://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
Hi Amit,
Currently, this is excel problem which I want to solve. I tried with less than or equal to or IF AND and OR with condition on excel, but still not get there.
I just do not want round circle number to be yellow as per below: