Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 scores based on user input as follows:
where I have measures of "score 1" and "score 2" based on slicers "company 1" and "company 2".
Is this possible?
Solved! Go to Solution.
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.
Thank you, that's exactly what I needed.
Hi,
the structure of the data is as follows:
company | factor | score |
Company A | cubit | 28.43 |
Company A | patching | 19.91 |
Company A | app_security | 62.38 |
Company A | dns | 77.68 |
Company A | network | 45.36 |
Company A | social_eng | 88.14 |
Company A | leaked_info | 98.09 |
Company A | ip_rep | 50.84 |
Company A | hacker | 38.09 |
Company A | endpoint | 21.06 |
Conglomerate B | cubit | 97.86 |
Conglomerate B | patching | 80.66 |
Conglomerate B | app_security | 23.45 |
Conglomerate B | dns | 15.25 |
Conglomerate B | network | 58.67 |
Conglomerate B | social_eng | 7.83 |
Conglomerate B | leaked_info | 17.57 |
Conglomerate B | ip_rep | 46.16 |
Conglomerate B | hacker | 9.3 |
Conglomerate B | endpoint | 81.35 |
Consortium C | cubit | 79.36 |
Consortium C | patching | 10.43 |
Consortium C | app_security | 29.81 |
Consortium C | dns | 65.31 |
Consortium C | network | 26.07 |
Consortium C | social_eng | 50.67 |
Consortium C | leaked_info | 81.28 |
Consortium C | ip_rep | 57.27 |
Consortium C | hacker | 37.2 |
Consortium C | endpoint | 33.2 |
and my two measures are:
score 1 = calculate(sum('Factors'[score]), 'Factors'[company] = "Company A")
and
score 2 = calculate(sum('Factors'[score]), 'Factors'[company] = "Conglomerate B")
but I want to create score 1 and score 2 based on slicers for end-user input instead of hard coding them.
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.
Hi @AndrewPF ,
I'm not quite clear what's the data structure your modle is. I create a sample:
But seems it's not quite the same with yours. Please clarify more details.
Best regards,
Community Support Team_yanjinag