Forum Discussion
AndrewPF
3 years agoHelper V
radar (spider) chart with two measures from same data source
I am using the SpiderChart by visiochart to show scores across different security factors for two different companies. However, these scores are currently hard coded and I want the chart to show...
- 3 years ago
Hi AndrewPF ,
If you mean select two values in the company slicer, score1 for the first and score2 for the second, modify the formula to:
score 1 = CALCULATE ( SUM ( 'Factors'[score] ), 'Factors'[company] = MINX ( ALLSELECTED ( Factors[company] ), 'Factors'[company] ) )score 2 = CALCULATE ( SUM ( 'Factors'[score] ), 'Factors'[company] = MAXX ( ALLSELECTED ( Factors[company] ), 'Factors'[company] ) )Get the same result with the hard coding formula:
I attach my sample below for your reference.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AndrewPF
3 years agoHelper V
Thank you, that's exactly what I needed.