They are in the same table.
Tech Name, KPI name
11, Te accepteren klanten
12 Te continueren klanten
13 Te accepteren opdrachten
E.g. first kpi box should only show numbers 11, 12 and 13
second box 21, 22, 23
Problem is, That suppress zeroes removes also correct kpi's (from the box) which count 0, If i remove the suppress I also get the other kpi's with - symbols in the expression. (because no expression if off course defined for them in the box.)
Continuing on what I'd said earlier, you'd use [Block 1 KPI name] as the dimension for one of your charts, and presumably have other charts with [Block 2 KPI name] and so forth. You would suppress the dimension when null, not suppress zeros for the KPIs themselves.
But I'm really not sure I understand what you're doing and what the problem is.
If I understood this correctly you were making an effort to build a scorecard with custom KPI list? Can you share more details, how did it go, what was your plan to map measure to "KPI Name... row" from excel data?
I wasn able to find any "live" examples of similar.
Thank you and best regards,