Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

Unsolve screen short.

Solved Screen short

 

I tried IF and OR condition but I am still not get there. I want to show yellow in cell amount if there is any two number come cell at same time. It does not matter what number come. But if there is no amount like zero than color must be white and if only one cell have amount than also white. 

If any one could help will be appreciated.

Thanks

 

 

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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: