Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have created a visual for correlation between product families to find out which 2 families are ordered together.
X and Y axes have product families and cells contain the count of orders when these two product families were ordered together. However when i filter the count of orders , the filter gets applied at a row level and not just at the cells.
Below is the visual without any filter
Filter of count of orders > 4 is applied to above visual. As it is seen values 3 and 1 are also visible. The cause is that for e.g. Media and Play & Fun have a count of 4. Hence Media cannot be eliminated from product families. Now power bi shows all product families that have a correlation with media irrespective of the value is > or <=4.
Kindly help with this issue.
Regards,
Prabha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.