Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

3 Replies