Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create a Distribution chart by bucketizing a measure

Hello friends. Imagine my scenario as part of Supply Chain data where users are ordering items.       In this table, I created "Average (days)" as a measure that calculates the average days...
Need Help
  • gmsamborn's avatar
    gmsamborn
    2 years ago

    Hi Anonymous 

     

    I created a bucket table with 3 columns: Bucket (ie. 0-10), Min(0) and Max (10) for each bucket.

     

    I wrote 1 measure.

     

    Count = 
    COUNTROWS(
        FILTER(
            ALL( 'Table' ),
            'Table'[Average (days)] >= SELECTEDVALUE( 'Buckets'[Min] )
                && 'Table'[Average (days)] <= SELECTEDVALUE( 'Buckets'[Max] )
        )
    )

     

     

    The ALL() might have to be changed to ALLSELECTED() depending on your needs.

     

    Let me know if you have any questions.

     

    Create a Distribution chart by bucketizing a measure.pbix

     

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

Anonymous 

cant you create the average as calculated column in your table . 

 

then use the create group builtin in feature in power bi to create the bins base on the calculated column. 

 

 

 

 

 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Actually I cant. The logic to check user selection and get the average duration only works as a measure.

  • gmsamborn's avatar
    gmsamborn
    Super User
    2 years ago

    Hi Anonymous 

     

    I created a bucket table with 3 columns: Bucket (ie. 0-10), Min(0) and Max (10) for each bucket.

     

    I wrote 1 measure.

     

    Count = 
    COUNTROWS(
        FILTER(
            ALL( 'Table' ),
            'Table'[Average (days)] >= SELECTEDVALUE( 'Buckets'[Min] )
                && 'Table'[Average (days)] <= SELECTEDVALUE( 'Buckets'[Max] )
        )
    )

     

     

    The ALL() might have to be changed to ALLSELECTED() depending on your needs.

     

    Let me know if you have any questions.

     

    Create a Distribution chart by bucketizing a measure.pbix

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thank you! that worked.

       

      I'm trying to visualize this using bar charts. Would you be able to know how to create bins? Like for example, I want user to select bins of 10, 20, 30, 30 etc. Is there a way to show this? Also what if the duration between two tasks is like say 1000 days. 

       

      thanks