Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gomezc73
Helper IV
Helper IV

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.