Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Those seem to be unrelated things. Your quadrants should always be present on the chart, so your filter would be more like a highlighter?
you are right. The quadrants will be always there, however, I want to present only those selected from the slicer.
Go with the highlighter, don't waste your time on the filter.
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |