cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AbelMartinez
Regular Visitor

Power KPI Matrix 3.1.1

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

 

1 ACCEPTED SOLUTION
AbelMartinez
Regular Visitor

Hi all, finally I found the solution by myself. Metric name in the metric table MUST match measure field.

View solution in original post

1 REPLY 1
AbelMartinez
Regular Visitor

Hi all, finally I found the solution by myself. Metric name in the metric table MUST match measure field.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors