Forum Discussion

DRJ1994's avatar
DRJ1994
Icon for Helper I rankHelper I
4 years ago
Solved

Merging several fields to create an 'Other' Category

Hi guys,

 

Hope somebody can help with my query.

I am working on a report that has a variety of categories that are not really relevant or not necessary for the report. I would like to combine all of these to create an 'other' category.

 

Does anyone have any idea how I would achieve this please? I imagine there will be some Dax related but I am not 100% where to start.

 

I have attached a screenshot of the categories I would like to merge. All of the ticked options are the ones I would like to be under the 'other' category.

 

 

Thanks in advance.

DRJ.

Need Help
Tips and Tricks

2 Replies

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi DRJ1994 ,

     

    If you right click on the dimenstion on powerbi desktop, you will see and option to cerate a new group. You can add your fields to other as required.

     

     

    Hope this helps.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi DRJ1994 ,

     

    You can try like below and edit this group.

     

    For more details, you can read below document:

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


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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