Forum Discussion
Help please ! - MultiCard KPI show top customer per category problem
Hi,
I have a multi-row card visual. Aside from below metrics, I want to be able to display top customers in rank by category using only one measure.
But what I created was three sets of measures with formula basis of:
Those highlighted in red are not applicable for that category. I want to be able to eliminate those either by hiding it or by creating a measure.
You won't be able to alter the title, but you could try:
Top Customer = SWITCH( SELECTEDVALUE( 'Main Table'[Plan_Variant_Group] )
, "Adaptive Mobility", [Top Customer Adaptive Mobility]
, "BMP", [Top Customer BMP]
)
etc
2 Replies
- AllisonKennedy
Community Champion
You won't be able to alter the title, but you could try:
Top Customer = SWITCH( SELECTEDVALUE( 'Main Table'[Plan_Variant_Group] )
, "Adaptive Mobility", [Top Customer Adaptive Mobility]
, "BMP", [Top Customer BMP]
)
etc
- AnonymousNot applicable
Yes, I was able to mark it as the correct solution