Forum Discussion

Karim_Hossam's avatar
Karim_Hossam
Microsoft Employee
8 years ago
Solved

dates on Y axis

Hello, I am trying to create a tracking report, to show either ticket has been updated in the same date of creation or not, I think about Line chart , but the issue is that I don't know how to prese...
  • v-jiascu-msft's avatar
    8 years ago

    Hi Karim_Hossam,

     

    I'm afraid it's hard to do with Power BI native visual. Maybe you can try a R visual. You can try it in this file.

    1. Reformat the data.

    dates_on_Y_axis

    2. Create a R visual.

    library(ggplot2)
    dataset$Value <- as.Date(dataset$Value, "%Y-%m-%d")
    ggplot(data = dataset, aes(x = dataset$"Ticket ID", y = dataset$Value, group = dataset$Attribute)) + geom_line() + geom_point()

    dates_on_Y_axis2

     

    Best Regards,

    Dale