How to use colourmap or colour gradient on scatterplot based on third column

[DonWampone]

Hello community,

I need to create a scatter plot in Power BI, where I have two or three different groups with different colours.

The colour of each group should be a colourmap, or follow a colour gradient with only one hue (for example from lime green to dark green) based on the value of another column provided in the table.

So lets say I have for example a scatter plot with green and blue dots, and the underlying table contains a column x which has not been used so far in the plot.

I need the colour of the green dots be darker if the value of x is high, and brighter, if the value of x is low.

Likewise the colour of the blue dots should be darker for high x, and brighter for low x.

I would apreciate any help, thank you in advance!

Best regards

[v-frfei-msft]

Hi @DonWampone ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[DonWampone]

Hi,

@v-frfei-msft , here is the one drive link with the data.

https://1drv.ms/f/s!AqlBeIoiUeZNdNa7b7R1mvEiM-A

What I need, is that the gradient or the intensity of the colour of the dots depends on the value of the column 'running_time'. 

For example, if the value of 'running_time' is high, the dots should be in a darker colour.

Best regards