Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello
Let's see if anyone knows how I can change the design of an array that is currently like this (image 1) for the second image.
What I have now I have done through the following measure where I group the different calculations for all the sections (total, non-repairable...) and the structure is taken from an excel table that I have not related to anything.
Matriz objetivo facturacion anual =
VAR calc = IF(SELECTEDVALUE('Tabla objetivo facturacion anual TALLER'[Concepto])="Totales",[Total Reparaciones 2],IF(SELECTEDVALUE('Tabla objetivo facturacion anual TALLER'[Concepto])="No Reparables",[Rep. No Reparables],IF(SELECTEDVALUE('Tabla objetivo facturacion anual TALLER'[Concepto])="Venta Recambios",[Rep. Venta Recambios],IF(SELECTEDVALUE('Tabla objetivo facturacion anual TALLER'[Concepto])="Garantias",[Rep. Garantia]))))
return
calc
Excel table:
In the end, what I want a little bit is to be able to put a subrow like the one that comes out that says Quantity, that the Repairs level can be put in the middle....
Thanks a lot.
I don't see this option you mention, could it be because I use a measure to group all the values? Also apart from that, you can put an intermediate line (in the capture it is the one that says Quantity)
https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Scroll down to Stepped Layout with Matrix Visuals
| User | Count |
|---|---|
| 55 | |
| 37 | |
| 23 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 58 | |
| 39 | |
| 21 | |
| 21 |