Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 present the dates (creation date and updated date) on the Y axes, could someone advise, how I can do this?(I already have this date in excel(ticket ID//creations date//updated date )
as example I want to show creation date instead of 1 and updated date instead of 2(in the below screenshot)
Solved! Go to Solution.
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.
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()
Best Regards,
Dale
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.
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()
Best Regards,
Dale
@Karim_Hossam what does your data model look like?
if you want to create a measure against 2 dates you will need to have an active relastionship for one date and an inactive for the other and then use the userelationship dax command, you will also then need to have a calendar table, can you screen shot your model?
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |