Forum Discussion
Reporting Histogram
Hello all! I have data which looks likes it is below. I am looking to create a sort of Histogram which shows the amount of Goals a Person has. So Person 22222222 would be in a 5, 1111111 in a 3, 33333 in a 2, and 55555 in a 1 sort of bucket. I was wondering how I would be able to like bucket these things into a measure or calculation or some sort so that I can create a histogram?
| PersonID | Goal |
| 22222222 | Savings |
| 22222222 | Debt |
| 22222222 | Timeline |
| 22222222 | Search |
| 1111111 | Savings |
| 1111111 | Search |
| 1111111 | Timeline |
| 33333 | Savings |
| 33333 | Debt |
| 55555 | Search |
Hi Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure = CALCULATE(COUNT('Table'[PersonID]),FILTER(ALL('Table'),'Table'[PersonID]=SELECTEDVALUE('Table'[PersonID])))If I hvae misunderstood your meaning, please provide pbix file (or some sample data ) without privacy information and desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure = CALCULATE(COUNT('Table'[PersonID]),FILTER(ALL('Table'),'Table'[PersonID]=SELECTEDVALUE('Table'[PersonID])))If I hvae misunderstood your meaning, please provide pbix file (or some sample data ) without privacy information and desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , You can check some Histogram visual
Or bar visual with countrows(Table) measure
