Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
rsbin
Super User
Super User

Help with R Script - Reverse Colour Gradient

Good Afternoon,

First time using the R Script Visual.  Almost got it to where I need it, except for one hiccup.

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script: 

# dataset <- data.frame(WFD, VisitCount, AvgTIY)
# dataset <- unique(dataset)

# Paste or type your script code here:
library(ggplot2)
ggplot(data=dataset, aes(x=VisitCount, 
                         y=WFD)) + 
   geom_point(aes(colour=AvgTIY), size=7) +
   scale_fill_brewer(palette = "Blues")

This code gives me this visual:

rsbin_0-1646858594414.png

I would like to reverse the colour gradient so Light is low and Dark is high. 

Any help from R users is much appreciated.

Thanks and Best Regards,

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @rsbin 

 

You can use a reverse scale, but this will also flip the legend to start at the top:

Example:

ggplot(faithfuld, aes(waiting, eruptions)) +
    geom_raster(aes(fill = density)) +
    scale_fill_continuous(trans = 'reverse')

 

Here is the related document, hope it can help you.

https://stackoverflow.com/questions/43515112/reversing-default-scale-gradient-ggplot2 

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-zhangti,

Appreciate the reply.  I have seen this question on stackoverflow and it did not help me.  I am working with points and have tried numerous combinations of code.  Hence eventually posted here in hopes of getting an answer that applies to my scenario directly.

Do appreciate you taking the time to reply, but am still in need of help and/or further direction.

Thanks and Kind Regards,

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.