cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gomezc73
Helper I
Helper I

Problem to generate Subtotals with more descriptive fields

Hello,

 

   Hi Guys, I have problem with my report, because i have a table with data similar to this:

   

CategoryCode of the productdescription of the productSales MaySales AprilVar
Bicicletas StandardM01-01RBicicletas STD Roja12010020
Bicicletas StandardM01-01ABicicletas STD Azul200230-10
Bicicletas StandardM01-01VBicicletas STD Verde12010020
Bicicletas ElectricasM02-01RBicicletas Electrica Roja12010020
Bicicletas ElectricasM02-01ABicicletas  Electrica  Azul200230-10
Bicicletas ElectricasM02-01VBicicletas  Electrica  Verde12010020

 

And I need generate my dashboard with subtotals but including the columns "Code of the product" and "description of the product".

 

I tried with Matrix but I only can display or de code of the product or de description, but not both of them.

 

    By example:

                                         Sales May     Sales April      Var
Bicicletas Standard                 440             430             30
        M01-01R                        120             100             20
        M01-01A                        200             230            -10
        M01-01V                        120             100             20
    

  With the Icon "table" I can display all columns i need, but I can't generate subtotals by Category, only it has Grand Totals.

 

  Is possible In PBI generate a  Matrix or table in the dasboard, with more descriptive fields?(In my real data i have more columns that i would like to display by example Brand, Extras, Rin#, etc)

 

I would like something like that: (Because my users frecuently download the data to Excel)

   

CategoryCode of the productdescription of the productSales MaySales AprilVar
Bicicletas StandardM01-01RBicicletas STD Roja12010020
Bicicletas StandardM01-01ABicicletas STD Azul200230-10
Bicicletas StandardM01-01VBicicletas STD Verde12010020
   SUB TOTAL Bicicletas Standard44043030
Bicicletas ElectricasM02-01RBicicletas Electrica Roja12010020
Bicicletas ElectricasM02-01ABicicletas  Electrica  Azul200230-10
Bicicletas ElectricasM02-01VBicicletas  Electrica  Verde12010020
   SUB TOTAL Bicicletas Electricas44043030
  GRAND TOTAL88086060
1 ACCEPTED SOLUTION
FrankAT
Community Champion
Community Champion

Hi @gomezc73 

at the bottom of my first reply you'll find an attached pbix file.

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

 

View solution in original post

3 REPLIES 3
FrankAT
Community Champion
Community Champion

Hi @gomezc73 

take a look at the following solution:

 

29-08-_2020_23-17-56.png

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

thank you very much.. thats is just i needed..

 

Could you please explain me how you get this effect in the matrix??..

 

Capture.JPG

FrankAT
Community Champion
Community Champion

Hi @gomezc73 

at the bottom of my first reply you'll find an attached pbix file.

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

 

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors