Problem with conditional formatting in column chart

[skean21]

Dear community, 

I have the following problem creating a conditional formatting in a column chart:

In the visual there is no graduation shown, all columns have the same color.

I created this matrix visual, where data is shown like this:

Name	Difference	Margin Index
Product A	31055	84,22179718
Product B	18916	110,8132923
Product C	-17224	79,34762554
Product D	-23317	9,246055122

Then I created a column chart shows the value "Difference" for each product.
I have set a conditional formatting for the chart based on the field "Margin Index" with min-max option selected.

All the columns have the same color, there is no graduation. Also, when I drag the field "Margin Index" into "QuickInfo", every column shows the same value (440.000).

"Name" and "Difference" come from table A, "Margin Index" is a calculation in table B.

The tables are joined based on "Name" from table B to table A.

In the table structure of table A, each product has several entries. In table B, there is only 1 entry for each product (sample below)

table A:

Name	Difference
Product A	10
Product A	15
Product A	100
…
table B:
Name	Margin Index
Product A	84,22179718
Product B	110,8132923
Product C	79,34762554
Product D	9,246055122

Any idea?

[v-lili6-msft · Accepted solution]

hi @skean21 

You just need to adjust it by these two ways:

"Name" and "Difference" come from table A, "Margin Index" is a calculation in table B.

1.  Please use "Name" from table B.

2. Set cross filter direction is "Both" instead of "Single"

Then it should work.

Regards,

Lin