Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Need help aggregating and filtering the underlying data by date.
Peter, James and John perform actions (they read books and/or papers) on dates January 1 to January 9.
Date | Action | Person |
jan 1 | Book | Peter |
jan 2 | Paper | James |
jan 2 | Book | John |
jan 4 | Book | Peter |
jan 4 | Book | Peter |
jan 5 | Paper | James |
jan 6 | Book | James |
jan 7 | Paper | John |
jan 8 | Book | Peter |
jan 9 | Paper | Peter |
I want to aggregate this data by Action to show how many times a certain action was performed by somebody during a given date interval. And I must be able to filter dates. If we take the data over all dates we get:
1 | 2 | >=3 | |
Book | 2 | 1 | |
Paper | 2 | 1 |
This shows that in the full time interval 2 persons read a book ONE time (James and John), and 1 person read a book AT LEAST THREE times (Peter, he did it 4 times).
Also, 2 persons read a paper ONE time and 1 person read a paper TWICE.
If we take January 2-6 we get this:
1 | 2 | >=3 | |
Book | 2 | 1 | |
Paper | 1 |
Here we see that again 2 persons read ONE book and 1 person read TWO.
And 1 person read the paper TWICE.
So, I need to aggregate like this, filter by date and show number of events like 1, 2, and >=3.
Ideas?
@DrH , I think you need Dynamic Segmentation Bucketing Binning on count measure, refer example
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Thanks for the attempt, but nope, that is not what I am looking for.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
20 | |
7 | |
6 | |
5 | |
5 |
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |