Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Visually Designing Matrix

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

apenaranda_1-1717052203591.png

apenaranda_0-1717051937413.png

Excel table:

apenaranda_2-1717052287507.png

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.

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

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)

Transform121
Helper I
Helper I

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

 

Scroll down to Stepped Layout with Matrix Visuals

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors