Hello,

I am new to R. I am trying to create a time series plot in powerbi using R. The below code I used in powerbi R visualization and got the time series visualization which I have attached with the title "Decomposition of additive time series".

```
dataset <- as.Date(dataset$Date)
data.ts = ts(dataset, frequency=12 , start=c(2016,1), end=c(2019,1))
data.tsdeco<- decompose(data.ts)
plot.ts(data.ts)
data2 = window(data.ts, frequency =12,start=c(2016,1), end=c(2019,1))
plot(data2)
data2deco <- decompose(data2)
plot(data2deco, col = "red", lwd =4)
rect(xleft=2017,xright=2018,ybottom=range(data2deco$random),ytop=range(data2deco$random),density =10, col="red")![forum%20ts|690x320](upload://c2T7qAJEHfNifXlB3CDU7iMQSlM.png)
```

The .csv source file has the below sample data. It has 100's of Item Number for different date from 2016 till 2019 with date format first of every month.

|Item |Date |Qty |

|1012-0006|1/1/2016|81200|

|1012-0006|8/1/2016|81200|

|1000-0747|12/1/2017|38880|

|1000-0747|2/1/2018|36880|

|1012-0136|12/1/2017|36620|

|1012-0136|2/1/2017|35000|

|1012-0006|10/1/2017|34400|

|1000-0747|8/1/2018|33836|

If I run the .csv file in R and see the structure of the data. It gives the structure for the 3 columns. It shows Item Number as Factor, Date as Factor,Qty as Int.

My desired result requirement:

- In the time series decomposition I need date in the format "01/01/2016, 02/01/2016..." in the x-axis and the Quantity in the Y-axis.(Currently it is showing "2016,2016.5.." int the x-axis)

2)If I move over any points on the line in time series,it should show the data label value for the current time period.

Please note, since this is my first post I am not able to attach more than 1 picture for reference.

Thank you in advance.