Correlation plot filtering

[Anonymous]

Hi All,

I'd like to create a correlation matrix between the porduct groups with a total revenue (based on invoice) filter.

• Without any filtering I can see every groups (A..I):total

• But when I set the filter to >0 only the group E and I remains

0

• After that, if I set the filter to >15 000 group A disappears but more groups appear on the chart:15000

• With filtering >50 000 every group is on the chart:

50000 

The total revenue (filtering value) and the group's figures come from the same query.

Thanks your answer in advence!

BR,
Aron

[Anonymous]

Could somebody help me?

[Anonymous]

Hello Lucien,

my original pbix has more than 10 millinos rows, so I created a filtered version with 500k rows for you: https://drive.google.com/file/d/1KtNBYc4NnLkz6qLtad3rPN3ZBePx37BY/view?usp=sharing

It has the same error, If I don't use the filter I see every group, but when I set it to >0 then group A, B and C disappear. Filtering >15.000 these groups are in the corr matrix again.

Thanks your help in advance!

BR,

Aron

[v-luwang-msft]

Hi @Anonymous ，

Not very clear ,could you pls share your pbix file and expected output when different filter.Remember to remove confidential data.

Best Regards

Lucien