Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. 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.
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.