Forum Discussion
Multiple Condition Conditional Formatting for a Line and Clustered Column Chart
Hi All,
As above, Im reporting on a Measure i have already created where Total Open (CurrentStatus)tickets are shown.
Now of these Tickets they will have a Given priority (Low, Medium etc...)
We have certain KPI's where total Open Low should be less then 50, Medium less then 30 and so on.
So I wish to create a conditional filter that will have the Total Count of low tickets red when above 50 and green when under etc.
I've tried this example based on another post but it wont let me select the field in 'Format by: Field value'
Thank you.
Anonymous , As per what I got.
You need return color if you want to use field value
like
IF(max(Tickets[Priority])="Low" & Sum(Tickets[Total Open]) <=50, "green", "red")
other 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
1 Reply
- amitchandak
Super User
Anonymous , As per what I got.
You need return color if you want to use field value
like
IF(max(Tickets[Priority])="Low" & Sum(Tickets[Total Open]) <=50, "green", "red")
other 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