Weekly graph based on two different columns

[Anonymous]

Dear community,

I just started working in Power BI a couple of weeks ago and it's been quite the learning curve so far, but I seem to have got a bit stuck and I apologize if this question came up before in another thread.

Basically, I am working with Incident Reports (from HPSM), and I have distinct fields of Opening Date, Resolving Date & Closing Date.

Out of these three fields I am trying to put together a weekly monitoring graph, so I added in my Excel source a weeknum column based on open date and another one for Resolved or Closing Date (whichever is older).

Now that I have two different columns containing the week number, is there a possibility to display the number of open / resolved / closed tickets on a column chart with the week number as axis values?

I tried linking both columns to that axis value field, but nothing seems to happen.

Thank you very much in advance for your help.

[Anonymous]

Hello @amitchandak @Anonymous 

Thank you both for your suggestions, I tried to set up a calendar and make use of the USERELATIONSHIP functionality.

For some reason, though, I'm not getting the month as the axis value in the chart.

Is it maybe because my columns contain both date & time values?

From what I could see in your examples, the columns contained only the date value and not the time.

I can't seem to find a button to attach a file to my post, but I have added part of my csv data here .

Thank you once again for your support, even though I barely scratched the surface, this is turning out to be quite the learning experience. 😄

[Anonymous]

Hi @Anonymous ,

If i understand you correctly, you will need to inactive one of the relationships and use USERELATIONSHIP() function.

Check the topic and see if it helps.

https://community.powerbi.com/t5/Desktop/Working-with-2-Dates/m-p/841997

If not, Please share some sample data and expected out put to us.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[amitchandak]

@Anonymous , to deal with open and close dates refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

To deal with week refer

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123