Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi, I need help in creating two line graph for 2 different date columns in power BI. Snapshot : I have two columns in a file with the date of the tickets entered and another column for the date of those ticket completed. However I need to see the days on which these tickets were entered and closed. Any help would be appreciated
First column (Entered Date on)
Second Column (Date Completed on)
The idea is to get the statistics of each count per day in X axis.
I am looking to merge both the below stats.
My data source
Date Entered On | Date Completed on |
01-04-21 | 10-04-21 |
01-04-21 | 10-04-21 |
01-04-21 | 10-04-21 |
01-04-21 | 10-04-21 |
01-04-21 | 10-04-21 |
01-04-21 | 05-04-21 |
01-04-21 | 05-04-21 |
01-04-21 | 05-04-21 |
01-04-21 | 05-04-21 |
02-04-21 | 05-04-21 |
02-04-21 | 05-04-21 |
02-04-21 | 05-04-21 |
02-04-21 | 05-04-21 |
05-04-21 | 07-04-21 |
05-04-21 | 07-04-21 |
06-04-21 | 07-04-21 |
06-04-21 | 07-04-21 |
06-04-21 | 07-04-21 |
06-04-21 | 07-04-21 |
06-04-21 | 07-04-21 |
07-04-21 | 08-04-21 |
07-04-21 | 08-04-21 |
07-04-21 | 08-04-21 |
07-04-21 | 08-04-21 |
07-04-21 | 09-04-21 |
07-04-21 | 09-04-21 |
07-04-21 | 09-04-21 |
08-04-21 | 09-04-21 |
08-04-21 | 09-04-21 |
08-04-21 | 09-04-21 |
Solved! Go to Solution.
Hi, @Anonymous
You can create a calendar table and two measures.
Like this:
Table 2 = CALENDAR(DATE(2021,4,1),DATE(2021,4,31))
complete =
CALCULATE (
COUNT ( 'Table'[Date Completed on] ),
FILTER (
ALL ( 'Table' ),
'Table'[Date Completed on] = SELECTEDVALUE ( 'Table 2'[Date] )
)
)
enter =
CALCULATE (
COUNT ( 'Table'[Date Entered On] ),
FILTER (
ALL ( 'Table' ),
'Table'[Date Entered On] = SELECTEDVALUE ( 'Table 2'[Date] )
)
)
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
You can create a calendar table and two measures.
Like this:
Table 2 = CALENDAR(DATE(2021,4,1),DATE(2021,4,31))
complete =
CALCULATE (
COUNT ( 'Table'[Date Completed on] ),
FILTER (
ALL ( 'Table' ),
'Table'[Date Completed on] = SELECTEDVALUE ( 'Table 2'[Date] )
)
)
enter =
CALCULATE (
COUNT ( 'Table'[Date Entered On] ),
FILTER (
ALL ( 'Table' ),
'Table'[Date Entered On] = SELECTEDVALUE ( 'Table 2'[Date] )
)
)
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Any help on this would be appreciated, Although it looks simple but I guess its difficult. @
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
118 | |
79 | |
47 | |
45 | |
32 |
User | Count |
---|---|
172 | |
90 | |
66 | |
46 | |
45 |