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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Daxhughes
Regular Visitor

Help with histograph

 

does this make sense? Do I need more detail here?

 


I am trying to run a histograph for days on market for a subdivision. I want to take all of the data that closed 0-30 and have in one column; 31-60 in another column; 61-90 in a third; 91-120 in a fourth.

 

the data I need is days on market and closed dates which I have in an excel spreadsheet.

 

here is example of three. First property closed on 2/22 and was on market 1 day. Second closed on 6/22 and was on market 2 days. Third closed on 4/29 and wasn't on market a day before a contract. This is a sample where the spreadsheet is 125 properties.

 

2/22/22 0:001
6/22/22 0:002
4/29/22 0:000

 

 

 

any help would be greatly appreciated!! I'm new at this

1 REPLY 1
lbendlin
Super User
Super User

Read about column charts and binning. That'll give you the histogram you need.  Good thing that you have a fixed list of bucket ranges. It would be harder with dynamic bucket sizes.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.