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

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    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.

5 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        selimovd
        Most Valuable Professional
        5 years ago

        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
         
  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    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.