Conditional formatting works on Table but not on Matrix chart

[Georgia_H]

Hi all,

I need help to solve this conditional formatting issue that i encountered when i applied into Matrix chart.

Threshold Color Compliance is used as my conditonal formatting rules See Pic A:

When Diff_Week_on_Week is a Positive number then is 1 (will show Arrow Up)

When Diff_Week_on_Week is a 0, then 0 (will show Right Arrow)

When Diff_Week_on_Week is a Negative number then is 2 (will show Arrow Down)

Pic A:

Pic B:  It works perfectly with Table visual.

Pic C: It didnt work with Matrix chart because it will roll up and sum the numbers up

Does anyone has solution to this problem? Please advise.

Thanks in advance.

BR

[Georgia_H]

@amitchandak, how can i upload the PBI to you? I am still unable to resolve the issue with conditional formating.

[Georgia_H]

@amitchandak how can i upload the sample data in .csv format? It's not supported.

[amitchandak]

@Georgia_H , Can you print the diff value and check . I doubt some problem there

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Georgia_H]

@amitchandak,

As you can see in my screeshot, the Diff_Week_on_Week is output correctly.