Forum Discussion
Anonymous
6 years agoNot applicable
Chart based on measure buckets
Hello, Power BI community. I'm new to Power BI. Need your help. I have a table with field ID. Same ID may have multiple records in the table. Need to create a chart based on predifined buckets of number of records for each ID. Buckets are : Once, 2-3 times, 4-5 times, 6+ times. So axis is a bucket, value is a number of unique IDs in a bucket. Simple, right? Can't figure out how to implement it in Power BI. So far just created a simple SQL query that has all this info. But I'm wondering how to do it in Power BI.
Thank you in advance for your help
Hi Anonymous ,
I uploaded my test file. You can download and refer to it.
3 Replies
- v-eachen-msft
Community Support
- AnonymousNot applicable
Thank you so murch! Perfect and simple. Just wasn't familiar with DAX function.