Forum Discussion
PBI-Dash
4 years agoFrequent Visitor
Design layout for many KPI's on one sheet
Hi, I'm in need of help regarding design issues for a report I'm asked to improve/further develop. The design isn't very scalable today. And it's getting tricky with new markets/countries incomin...
- 4 years ago
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
amitchandak
Super User
4 years agoPBI-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