Group values in visualization to one value or higher

Hi, I have a simple data table as follow:


Each row represent one unique “URL” for one Video, “laugh_count” is integer from 0 - 20, “views” vary depending on videos.

I want to create a simple bar chart column with Average Views group by number of “laugh_count”, for “laugh_count” values of 15 and higher I only want to show only 1 column, averaging views for any videos with 15+ laugh_count.

How can I do this? Thanks for your help!

1 Like

Hi @Elquinox

You should be able to do this quite easily by using the binning/grouping function. I’ve included a link below

Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs

DJ

2 Likes