Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Define table cell by cell

I need to create a report using a table where I want to define data cell by cell. That is my example:     It is posible to do this on power by?   Regards
  • v-jingzhang's avatar
    5 years ago

    Hi Anonymous 

     

    A common practice is to group the original CUSTOMER values into several groups by creating a new group column, and use this group column in a table or matrix visual. Download the attachment for details.

     

    You could use below DAX codes to create a group column. Modify it per your need.

    Groups = 
    SWITCH (
        'Table'[TYPE],
        "A",
            IF (
                'Table'[CUSTOMER] IN { "1", "2" },
                'Table'[CUSTOMER],
                "Rest of Customer Type A"
            ),
        "B",
            IF (
                'Table'[CUSTOMER] IN { "5", "6", "7" },
                'Table'[CUSTOMER],
                "Rest of Customer Type B"
            )
    )
    

     

    Or you could also right click on CUSTOMER column and select New group. Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.