Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey there! =D
i just arrived at this company, witch they use tons of Excel sheets with dynamic tables, "vlookup" etc...
Anyway, the thing is i need to know how to create this kind of subtotal line between groups in a Power BI matrix/table, its like "Subtotal before contingency & tax benefits" followed by the next 2 lines with contingency & taxes, and only then the grand total, as in this excel table:
note: i'm using Matrix, not Table. With hierarchy in some groups, not all of them.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix
Thanks a lot, it helped me a lot here. But...
There are 3 points to be clarified yet. 1st is the most important to me right now
1º - How would i bring the Subtotal Row to the bottom of the table right before "CONTINGÊNCIA" row? - with that answer, i get my solution
2º - I need to order the rows by a certain sequence, as in the print (1º, 2º, 3º...), i'll try some measures/DAX tricks with RANKX, IF statements, VAR etc... And order the Level 3 Column by this Measure... Will it work? Cuz there are some "null" cells in this column
3º - Now i got some issues coloring specific Rows by its Level, but i'll try something like this tutorial https://www.youtube.com/watch?v=TwUKVrY8KE0
This is how i'm using the columns. The "blank" cells is "null"
Hi @Anonymous ,
Yesterday I wans't in my computer and today got to look at your information believe the best way is to create a parent child hierarchies.
Check the documentation below with a full explanation on how it works and how it can be implemented.
https://www.daxpatterns.com/parent-child-hierarchies/
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |