The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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