data change visualisation

[kongyuancn]

Hi There,

I have a problem: I want to show data changed in a matrix.

Let's say I have a table:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wck4sMVTSUfIsSc0F0YZKsToogkbYBI2BtAFM0AibdiMk7RgqjZFVGiNpN0AXNMImiKLdBJt2E2zaTbBpN8Wm3RSb301RtccCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Category = _t, Item = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Category", type text}, {"Value", Int64.Type}})
in
    #"Changed Type"

It looks like as followings:

Then I setup a matrix

Now I want to label data is changed among several categories. In this picture, I want to let Item1 Cat4 shows a different color because the data changed from 1 to 0. The to be compared categories are controlled by a slicer.

Please help to explain how to implement this.

thanks in advance

[mahoneypat]

Thank you for posting your data as M code. Makes it easier to help. Here's one way to do it.  Create a measure like this (replace Items with your actual table name), and use it as your background conditional formatting.

ValueChange =
IF (
    CALCULATE ( DISTINCTCOUNT ( Items[Value] ), ALLSELECTED ( Items[Category] ) ) > 1,
    "Blue",
    "White"
)

Pat

[kongyuancn]

Thank you Pat, is it possible to only label item1 cat4 (not the whole row)?