Forum Discussion
JohnSalt
2 years agoHelper I
KPI Indicator on table with values in rows
Hi I have a visual with the "Switch values to rows" option selected so I have months across the top and each row is a different measure, this works fine but I cant find how to add a KPI direction...
- 2 years ago
Here's a different approach that allows separate formatting for the metric value and trend arrow.
1. Create a disconnected table (no relationships) with a row for each metric:
2. Create measures:
Display Metric = SWITCH ( SELECTEDVALUE ( MetricTable[Metric] ), "Metric 1", [Metric 1], "Metric 2", [Metric 2], "Metric 3", [Metric 3] )Display Metric Icon = VAR vMetric = [Display Metric] VAR vResult = SWITCH ( TRUE, vMetric >= .1, UNICHAR ( 9650 ), vMetric > .05, UNICHAR ( 9654 ), vMetric <= .05, UNICHAR ( 9660 ) ) RETURN vResult3. Add fields to matrix (MetricTable[Metric] is in Rows field well):
4. Result:
Apply formatting/conditional formatting as required. The measure [Display Metric Icon] can be expanded to use nested SWITCH expressions, allowing you to specify different thresholds for each metric.
Anonymous
2 years agoNot applicable
Hi JohnSalt ,
Did DataInsights reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.
Best Regards,
Adamk Kong