Multiple Condition Conditional Formatting for a Line and Clustered Column Chart

[Anonymous]

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'

TotalOpen_ColourCondition = MAXX(FS,

IF(Tickets[Priority]="Low" & Tickets[Total Open] <=50, 1, 2))

Note:

Tickets[Total Open] is a Measure

Tickets[Priority] is a standard Column

What am I doing wrong?

Thank you.

[amitchandak · Accepted solution]

@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