Forum Discussion
Design layout for many KPI's on one sheet
PBI-Dash , Create a measure with these two values
measure = [NPS] & unichar(10) & [Measure 2]
And use that in matrix. Use conditional formatting to color each column
Color = Switch( True() ,
[NPS] > 75, "Green"
// Add other conditions
"Red"
)
Use it in conditional formatting using field value option
You’ve hit the “200-objects” trap. Fix it by making metrics switchable instead of duplicating visuals: use a Field Parameter so one KPI card flips between NPS/Responses, move Responses to a subtitle or tooltip, and show Country × Survey in a matrix or small multiples with conditional formatting. Keep a simple grid and use drillthrough for country detail instead of cloning pages. I wireframe this flow in Mokkup.ai first. The existing dashboard templates + drag-and-drop keep spacing consistent, and the export to Power BI file saves a ton of rebuild time.