Custom grouping of items

[Hawkeye]

Hi all, 

This is a bit different to the standard grouping that Power Bi offers as standard (selecting data and then right clicking) unless I am missing a trick.

I have a large array of labels in the Axis, however, some items are related in such a way that I'd like them to count towards a single total as opposed to being listed seperately. 

The best way I can think of describing it as that they're sub-projects of a main project; but due to the way the data is produced by the report (which I cannot alter at this stage) they are all listed as individual projects - I'd like to group them all and then have them stored under a single project heading on the Axis.

Does that make sense? Happy to demonstrate further if needed

Thanks

[Anonymous · Accepted solution]

@Hawkeye,

Could you please share sample data of your table and post expected result here? We will appreciate it if you can also post screenshot about your scenario.

Besides, you can check if the Power BI grouping feature  helps in your scenario.

Regards,
Lydia

[Hawkeye]

Sorry! I had read that page on Grouping tried it and then dismissed it as not working. 

What I needed to do was group the items on the table (Select > Right Click), move the new field out of legend and into Axis, and the Edit the Groups and untick the "Include Other Group" box.

Now I just have to work on tidying up the names! 

Thanks! 

[Anonymous]

@Hawkeye,

Could you please share sample data of your column and post expected result?

Regards,

[CahabaData]

off the cuff - it sounds like you need to add a calculated column to the underlying data set

possibly a measure but right now I think it is a fundamental group definition column.....