Issue with Power BI R Script Visual

[AdvOfJet]

Currently having an issue with the R script visual in Power BI. When running the graph, I can't get the format to read the entire date field - for example: 12/31/2023. Instead it breaks down the date field into Year, Quarter, Month, and Day. All of which cause issues with the visual.

When I run the visual in standard R I get the following.

When I run the visual in PowerBI R script, it shows the following.

I assume this is because of how PowerBI process date fields.

# dataset <- data.frame(Price, Year, Quarter, Month, Day, RK)

The actual columns on the table are

Price = Price offered
Ran = Date quote was ran
RK = Sales Person

I am using the following code.

library(ggplot2)
ggplot(dataset, aes(x = Year, y = Price) + geom_point()

What I can't figure out is how to make the r read the full date and plot according instead of just the year, month, or day. Using the "Ran" column name doesn't work.

[lbendlin · Accepted solution]

In the Power BI settings disable Auto Date/Time for the current file and globally.

[Anonymous · Accepted solution]

Thanks for the reply from lbendlin.

Hi @AdvOfJet  , 

As lbendlin said, you can disable Auto Date/Time feature, it won't automatically generate date hierarchies. 

You can also modify the date hierarchy directly:

 

Re-create the visual and modify the code:

library(ggplot2)

dataset$Date <- as.Date(dataset$Date)

ggplot(dataset, aes(x = Date, y = Profit)) + geom_point() + scale_x_date(date_labels = "%Y")

Result:

Best Regards,
Zhu

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

[lbendlin · Accepted solution]

In the Power BI settings disable Auto Date/Time for the current file and globally.