How to do 'group by' in power BI report

[Michael_Shown]

Hi,

I'm new to Power BI.

I have a very simple data set as below and I want end user(s) to group any column(s) from a single table.

Group By functionality is available in power query editor but I'm wondering if there's any way of grouping rows by a column in power bi report publishsed to power bi service.

Any comment will be very appreiciated.

 

Thank you.

[v-yangliu-msft · Accepted solution]

Hi  @Michael_Shown ,

Here are the steps you can follow：

1. Create measure.

Measure = 
    IF(
        ISINSCOPE('Table'[Item number]),
        
      MAX('Table'[Color])
        ,
        IF(
    ISINSCOPE('Table'[Color]),
      COUNTX(
            FILTER(ALL('Table'),'Table'[Color]=MAX('Table'[Color])),[Item number])
    ,
    COUNTX(ALL('Table'),'Table'[Color])))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[AnkitKukreja]

Hi @Michael_Shown 

Does this work for you?  If yes, just right click on your column from the table and use option create hierarchy.

attaching the pbix file for your reference.