Define table cell by cell

[Anonymous]

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 · Accepted solution]

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.

[selimovd]

Hey @Anonymous ,

how does you data look like?

If you have the 4 columns CUSTOMER, TYPE, SALES and PPL with the values mentioned above you can just display that as a matrix or table and you get the result like displayed in your example.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Hey @selimovd 

Origin data is a full sales data  with lot of customers and types.

Thay is why I need to specifiy row by row data I want to display.

Regards

[selimovd]

Hey @Anonymous ,

give an example of how your data looks and I can try to help you.

If you say "a full sales data" doesn't help.

You can also create multiple measures and show them on the x-axis if that helps:

Display DAX Measures in a Matrix on Rows - What the fact.bi

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Hi @selimovd 

Sorry if I have not been very clear, my data looks like this:

Regards