can we create a bar chart with two criteria that has two different date range value

[muhammedaslam02]

Is there any way I can create a bar chart number of tickets created and the number of closed tickets per month?As I have different date range columns for these two criteria

I have done an analysis on excel, and I am expecting data like below:

I have tried to create, but numbers are showing by created month tickets date range.

my visualisation value

Count of ticket ID- number of ticket ID

Count of Resolved&Closed = calculate(COUNTROWS(Data),FILTER(Data,Data[Status]="closed”))

Sample data below,

Ticket ID	Status	Created time	Closed time	Create measure month year	Closed measure month year
220688	Closed	25/07/2022 5:24	26/07/2022 11:56	202207	202207
214357	Closed	26/05/2022 11:16	6/09/2022 9:22	202205	202209
211330	Duplicate	26/04/2022 14:48		202204
216129	Duplicate	10/06/2022 9:39		202206
216755	Pending	16/06/2022 11:40		202206
210063	Pending	12/04/2022 11:46		202204
222231	Closed	8/08/2022 4:51	11/08/2022 10:27	202208	202208
222716	Closed	12/08/2022 4:52	15/08/2022 8:10	202208	202208
210771	Closed	20/04/2022 10:04	21/04/2022 8:55	202204	202204
209592	Closed	7/04/2022 12:20	7/09/2022 14:29	202204	202209
210062	Closed	12/04/2022 11:45	5/09/2022 13:54	202204	202209
210064	Closed	12/04/2022 11:49	23/09/2022 15:00	202204	202209
213538	Closed	18/05/2022 9:15	15/08/2022 9:16	202205	202208
216628	Closed	15/06/2022 10:09	18/08/2022 14:56	202206	202208
220874	Closed	26/07/2022 13:14	11/08/2022 11:07	202207	202208
212170	Closed	4/05/2022 14:27	18/07/2022 9:30	202205	202207
211557	Closed	28/04/2022 15:07	26/08/2022 9:22	202204	202208
223673	Closed	19/08/2022 7:51	31/08/2022 10:54	202208	202208

[muhammedaslam02]

Thanks for the support and soloution.
I have Changed my barchart to line and clustered coloumn chart.
Can any one help me as I want to add below values to line y axis
1)count of SLA Vilotaed per month
2)Count of "user1" per month

https://www.dropbox.com/transfer/cap_pid_ft:AAAAAB7o9L_Wqu7WvNnrZSWbJumuObCTE3L8mTC16n3_7IXsl3ey6_Y

[AlexisOlson]

I'd recommend creating a new post for this new question and explaining/showing what your desired result should look like.

How to Get Your Questions Answered Quickly

[AlexisOlson · Accepted solution]

Creating a date dimension table really helps here.

You can use the date dimension for your x-axis and then write measures for your columns like this:

Created Count = 
VAR _Year = SELECTEDVALUE ( Dim_Date[Year] )
VAR _Month = SELECTEDVALUE ( Dim_Date[Month] )
RETURN
    CALCULATE (
        COUNT ( Tickets[Ticket ID] ),
        FILTER ( Tickets, YEAR ( Tickets[Created time] ) = _Year && MONTH ( Tickets[Created time] ) = _Month )
    )

See the attached pbix. Preview:

[muhammedaslam02]

is there option to create barchart without edit data source. because my rest of the model depends upon this data structure?

[Anonymous]

I think you'd better transform your sourcing data first when you import. unpivot columns create and closed .