cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Karim_Hossam Regular Visitor
Regular Visitor

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 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 )Screenshot_1.png

as example I want to show creation date instead of 1 and updated date instead of 2(in the below screenshot)

1 ACCEPTED SOLUTION

Accepted Solutions
v-jiascu-msft Super Contributor
Super Contributor

Re: dates on Y axis

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

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
vanessafvg Super Contributor
Super Contributor

Re: dates on Y axis

@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?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Karim_Hossam Regular Visitor
Regular Visitor

Re: dates on Y axis

tets.png

v-jiascu-msft Super Contributor
Super Contributor

Re: dates on Y axis

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

 

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 6 members 2,927 guests
Please welcome our newest community members: