Category 1- Brand and Total again Category 2- brand total

[Anonymous]

I have data like below i want to display Total after brand 

Category1 having : Brand 1 ,Brand 2,Brand 3

Category2 having : Brand 4 ,Brand 5 ,Brand 6 

Ouput i want in below form 

Column A                 Column B         Column C 

Brand 1                       100                     500

Brand 2                       200                     300

Brand 3                       300                     100

Total Category1       600                      900

Brand 4                       700                       600

Brand 5                        800                       900

Brand 6                        900                       1000

Total Category2         2400                      2500  

And So on, having multiple categoery with brands and want show data within same form in Power Bi and totals as above how to show that. 

[parry2k]

Add a matrix visual, column a and brand column on rows, column b and c on columns and amount on value column, you can turn off column total if not required.

also do drill down to show brand value for each category.

[Anonymous]

@parry2kThanks for the reply but i tried that not able to show in same form 

coluld you please used data and share pbix file with me so i can implement in my pbix based on your example pbix file.

[parry2k]

can you put sample data in excel and share the file and then I will put pbix for you.

[Anonymous]

Brand under Category's

if see above sample data images Same report i need to prepare @parry2k please used this above data and share pbix with me unable to add excel giving error to me. 

[parry2k]

@Anonymous you can put in google drive or one drive and share the file, it will much easier that way 

[Anonymous]

I prepared excel but unable to shared when attaching it is giving me error invlid file type i tried both .xls and xlsx option