This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Hi all, I'm having problems when adding categories to the matrix in a column-based scenario.
All works fine, I have 2 metrics that are shown well. The problem appears me when I try to add Category and Sub-Category in the matrix. This is the process that I follow:
1. The 2 metrics show well in the matrix
2. I add "Metric Name" in the category field. Nothing happens, but it's normal.
3. The problem raises when I add "Sub-Category" after "Metric Name" in the category field from Metric table. The new sub-category column appears but then 1 metric dissapears from the matrix
4. Then I add "Category" after "Sub-Category" in the category field, new column appears but matrix shows nothing, it only shows the headers.
I checked the data, matrix properties and a lot of stuff but I don't found the solution. I reviewed the Matrix Sample which is working but I cannot find differences versus my matrix. I realize it must be a problem with my data or something else in my report but I can fix the issue. Any idea? I'm sure it must be something I'm doing bad, but I'm stucked. Any help is apprecied.
Thanks in advance,
Abel
Solved! Go to Solution.
Hi all, finally I found the solution by myself. Metric name in the metric table MUST match measure field.
Incidencia en formato condicional de Matriz de KPIs
Buenas tardes,
Me encuentro con un problema técnico en el visual de Estado de KPIs. Actualmente, la matriz muestra correctamente los iconos de semáforo para los indicadores antiguos; sin embargo, al intentar añadir un nuevo indicador con la misma configuración, el icono no se visualiza.
Adicionalmente, he detectado que si renombro cualquiera de los indicadores que ya funcionaban correctamente, el icono desaparece de inmediato.
Agradecería su apoyo.
Hi all, finally I found the solution by myself. Metric name in the metric table MUST match measure field.
Hi any chance you would show me how to do this.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.