Bar chart with multiple column reference

[kaushika]

I'm new to power bi, request your help in fulfilling this requirement.

Table design:

Ticket-id

Status

Ticketcreateddate

Ticketcloseddate

Ticketlastresolveddate

Idea is to create a chart based on status count by:

New - No of tickets which is created on that month(ref column name: ticketcreateddate) – status value should not be considered here

Closed: No of tickets with "closed" status for that month(ref column name: Status  , ticketcloseddate),

Cancelled : No of tickets with "cancelled" status for that month (ref column name: Status  , Ticketlastresolveddate).

Still Open: No of tickets with status "WIP" for the current month (ref column name: Status)

Status can hold values like Closed, cancelled, WIP . How to achieve this?

Need chart with x axis as months of the year. For an example need a representation similar to this for all months of current year:

[amitchandak · Accepted solution]

@kaushika , refer the approach in blog and the attached file

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...