Instead of hardcoding a number to use on formatting a table, allow users to use a measure/calculation (DAX) to format dynamically a table.
Is it not same as Color measure using field Option 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 examples of such meaures - And these work fine on table and Matrix . Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) 2018,"red","yellow")) 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,"green", /// Add more conditions "red" )
