Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Colour the visual based on slicer selection

Hello,

 

I have a dataset with information regarding transaction data.

 

I created a scatter plot which shows how the price of the products diverged from the average price for the particular product:

 

 

The dots are now coloured according to the product code. I also have an adjacent table where the basic statistics for each products are specified - average price, standard deviation etc. Once you select a certain product code, the visual looks like this:

 

 

The aim of this visualisation is to spot the price outliers for each product - as you can see above, almost every product was purchased for the value similar to the average, while for one transaction - the price exceeded the average 2x.

 

I would now like to get to the cause of the outlier - for this, I would like to have an adjacent slicer, on the selection of which the colouring of the bubbles would be changed - for instance, if I chose the "Contractor" in the slicer, I would like for the bubbles' colours' to be based on the different contractors (this way I could see if for instance the one outlier was caused by the fact that a different contractor was used). Then, if I chose "country", the bubbles would be coloured by the country of goods dispatch - again, if the one outlier was coloured differently, this would explain why the products were purchased with such price disrepancy.

 

I would like to compare the bubbles under several categories - such as contractors, countries, product category, purchase teams and so on. 

 

Is this obtainable using measures/bookmarks/...?

 

Thanks in advance.

3 Replies