Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Hi Guys, I have problem with my report, because i have a table with data similar to this:
Category | Code of the product | description of the product | Sales May | Sales April | Var |
Bicicletas Standard | M01-01R | Bicicletas STD Roja | 120 | 100 | 20 |
Bicicletas Standard | M01-01A | Bicicletas STD Azul | 200 | 230 | -10 |
Bicicletas Standard | M01-01V | Bicicletas STD Verde | 120 | 100 | 20 |
Bicicletas Electricas | M02-01R | Bicicletas Electrica Roja | 120 | 100 | 20 |
Bicicletas Electricas | M02-01A | Bicicletas Electrica Azul | 200 | 230 | -10 |
Bicicletas Electricas | M02-01V | Bicicletas Electrica Verde | 120 | 100 | 20 |
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)
Category | Code of the product | description of the product | Sales May | Sales April | Var |
Bicicletas Standard | M01-01R | Bicicletas STD Roja | 120 | 100 | 20 |
Bicicletas Standard | M01-01A | Bicicletas STD Azul | 200 | 230 | -10 |
Bicicletas Standard | M01-01V | Bicicletas STD Verde | 120 | 100 | 20 |
SUB TOTAL Bicicletas Standard | 440 | 430 | 30 | ||
Bicicletas Electricas | M02-01R | Bicicletas Electrica Roja | 120 | 100 | 20 |
Bicicletas Electricas | M02-01A | Bicicletas Electrica Azul | 200 | 230 | -10 |
Bicicletas Electricas | M02-01V | Bicicletas Electrica Verde | 120 | 100 | 20 |
SUB TOTAL Bicicletas Electricas | 440 | 430 | 30 | ||
GRAND TOTAL | 880 | 860 | 60 |
Solved! Go to Solution.
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)
Hi @gomezc73
take a look at the following solution:
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??..
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)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |