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

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)

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!