Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
siqcben
Frequent Visitor

Chart for amount of values that fall on combination of two dates

I have data like this:

 

IDCreated DateSubmitted Date
13/29/20244/12/2024
21/14/20241/24/2024
31/28/20242/1/2024
43/19/20243/20/2024
54/1/20244/1/2024
63/20/20243/28/2024
72/14/20242/27/2024
82/8/20242/20/2024
92/26/20242/28/2024
101/27/20242/6/2024

 

The submitted date will always be after the created date. I want to create a chart to show how many IDs fall on each combination of dates. I was imagining something like a scatter chart, but it seems there's no way to structure it this way (with a measure for count of IDs as values, and each date on one of the axes).

 

Does anyone know a visual that will allow me to do this? Again, scatter chart seems to make the most sense but doesn't seem to support this.

1 REPLY 1
amitchandak
Super User
Super User

@siqcben , you should Try Cohort Analysis in Matrix Visual:

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Anal...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors