How to add Group by column in single table in Power Bi desktop?

[JaipalAnu]

Hi All,

I am creating one report as per the requirement, the requirement is like below screenshot. So, the Card type is showing as grouping with multiple columns. But with in the column it is showing values also under column. I am not sure whether we can show like this in Power bi table or matrix visual, can you please help how to get it?

[v-zhangti · Accepted solution]

Hi, @JaipalAnu 

After testing, there may not be a way to display this in a single table. But you can try the following method.

Table:

New table = 
SUMMARIZE ('Table','Table'[Type],'Table'[External Chargeback Reason],
    "Card Type Grouping", "TOTAL RETAIL AND WHOLESALE",
    "Count", CALCULATE(SUM('Table'[Count]),ALLEXCEPT ('Table', 'Table'[External Chargeback Reason], 'Table'[Type])),
    "Amount",CALCULATE(SUM('Table'[Amount]),ALLEXCEPT ( 'Table', 'Table'[External Chargeback Reason], 'Table'[Type])))

Result:

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

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

[Ritaf1983]

Hi @JaipalAnu 
It seems regular hierarchical matrix like at the linked tutorial :

https://www.youtube.com/watch?v=qphVQdI5rQs

For more detailed and specific suggestions provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

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