How to apply Conditional Formatting based on previous cell value in Power BI?

Question

I would like to accomplish the following in Power BI, I have done it in Excel but I haven't been able to figure it out for Power BI. I have a Power Bi table that I need the values in rows to change color if it decreases or increases from the previous cell value. See an example of what it should look like after applying the conditional formatting.

Answer 1

You need a separate measure that calculates that change. With that in hand, you can apply Conditional Formatting to the Values column in your matrix, eg using the "change" Measure for Based on field.

Here's the doco:

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting