Forum Discussion
Using parameter as slicer
I’ve created the scatter chat below based on “SIZE” and “SCORE” metrics:
Size = CALCULATE(DIVIDE(SUM((table[Size_number])),COUNTROWS(table)))
Score = SUM(table[New_value])
Additionally, I create a parameter (slicer) through the option to considerer 4 measures (Big Bet, Incremental, Money Pit and Quick Win)
Parameter = {
("Big Bets", NAMEOF('Measure'[BB]), 0),
("Incremental", NAMEOF('Measure'[IN]), 1),
("Money Pit", NAMEOF('Measure'[MP]), 2),
("Quick Win", NAMEOF('Measure'[QW]), 3)
}
Measures:
BB = IF([Size]>3&&[Score]>72,"Big Bets","")
IN = IF([Size]<=3&&[Score]<=72,"Incremental","")
MP = IF([Size]>3&&[Score]<72,"Money Pit","")
QW = IF([Size]<=3&&[Score]>=72,"Quick Win","")
At the end, I want to filter the 'INITIATIVE' using a parameter as a slicer. However, I am not sure how to link the parameter to the graph. I believe there might be a missing link between them.
I appreciate any contribution to solve this issue.
Thanks
3 Replies
- lbendlinSuper User
Those seem to be unrelated things. Your quadrants should always be present on the chart, so your filter would be more like a highlighter?