Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. 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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 37 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 25 |